Can anyone help me retain precision points of a calculated field in a dataset?
I am running a basic formula to derive the calculated field, but I see that it is rounded off to 2 decimal points whereas I want to retain the precision to 6 (or more if possible). I have tried a few things to get it to work:
1 - Rounding off in the formula of the calculated field
2 - Multiplying with 1.00 - essentially trying to coerce the type to float
3 - Changing the number of decimal points - wherever possible.
But none of them have worked so far. Are there any settings etc that I can change to achieve this?
Corresponding values in Tableau and Quicksight are shared for reference:
Many thanks in advance!