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

Comments

3 comments

  • Avatar
    Janet Erdman

    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
  • Avatar
    Brian Wilson

    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
  • Avatar
    Janet Erdman

    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.