Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Disable Exponent format in Card Visualization

I'm having difficulty with making a card display as 0.00.   This is as the card displays now.               However, the same column displays as 0.00 in a table on the same report pag...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    I think this is caused by floating point imprecision.

     

    Try changing your data type to a currency type, seeing as how you're apparently working with money:

     

     

    Rather, you ought to do this at the query level, changing the data type to a fixed decimal type, which you ought to be doing anyway when working with money (I'm unsure if the currency format changes your underlying data to a fixed decimal type; do this if the first option doesn't help):

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I think this is caused by floating point imprecision.

 

Try changing your data type to a currency type, seeing as how you're apparently working with money:

 

 

Rather, you ought to do this at the query level, changing the data type to a fixed decimal type, which you ought to be doing anyway when working with money (I'm unsure if the currency format changes your underlying data to a fixed decimal type; do this if the first option doesn't help):