Forum Discussion
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...
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):
Try changing the Display Units setting on the card well from Auto to None.