Value 999,999,999.99 rounding up to show as 1B

Follow

Janet Erdman

May 11, 2020 22:38

Value 999,999,999.99 rounding up to show as 1B, how can I stop this as the client wants to see the actual value without it rounding up as the amount is exactly 999,999,999.99 not 1,000,000,000.00

1

• 

  Janet Erdman May 12, 2020 13:47

  Just as a FYI, the formatting is not check either for this and it is actually displaying as $1,000,000,000.00

  0

  Comment actions Permalink
• 

  Brian Wilson May 12, 2020 16:52

  Hey Janet,

  I created 3 new records with the decimal values of

  • 999,999,999.99
  • 999,999,999.999
  • 999,999,999.9999

  I was able to get the nines to show in each by unchecking each of the abbreviation checkboxes and by selecting a value of the number of decimals equal or greater than the number of decimals in the value.

  

  What's the actual value of the field you're trying to show? Is it exactly 999,999,999.99? Or is it 999,999,999.9999999999... ?

  If it's repeating, I think that Sisense will force a rounding at some point. Maybe you could truncate the value in SQL prior to display if that's the case?

  0

  Comment actions Permalink
• 

  Janet Erdman May 14, 2020 02:17

  Thank you so much for your assistance. By changing it in the cube to a decimal value versus Int or BigInt value it worked perfectly. 

  0

  Comment actions Permalink

Please sign in to leave a comment.