Defining Precision in measures

I’m trying to do a calculated measure, when I select the data type to decimal, it gives the correct answer but to the precision of 2 digits after the decimal point.

What I need is a precision of 3 decimal points.

If I define custom data type #,###.### then I get the data correct, but I don’t get 0.###, what I get as output is .### (without zero before the decimal point)

Any help on the same is much appreciated

1 Like

Hi @Chinmay

You are almost there: you may want to use custom formatting “0.00#” (it would always show the calculated value or 0 if empty in designated places, like 7.341, 0.123, 5.10, 0.00).

Best,
Ilze, support@eazybi.com

That did the trick.
Thank you @ilze.leite

But surprised when when I set the custom format #,###.### it didn’t worked but it worked when I set the format to #,##0.###