Hey All,

I have created a division calculated field and I need to sum the result of the division in one of my analysis.

The division is leading to very small decimal values almost uptil 8 decimals and Quicksight is rounding it to 4.

Since there are upto 3 lakh records, when I am summing up the division values(which is the final use case), I am getting incorrect no.

I have tried multiplying the numerator by 1000 so I can get closer to the actual but since the decimal places after division comes are upto 8 , multiplying by 1000 isn’t helping and when multiplying by a bigger number it’s exceeding the quicksight limit.

Can somebody please help on how do I go about with it?

Thanks