Calculate correct number of digits after decimal point

[D3K]

Hello everyone!

Maybe this question was solved before, but I didn't find the answer.

I have what-if parameter and 2 measures:

1. parameter - cost change, %

2. "cost, fact"

3. "cost, scenario", which is calculating as "cost,fact * (1+[% of cost change])"

But, there are different values even when parameter is equal 0. When I increased the number of digits after decimal point, I saw that calculated measure "cost, scenario" is counted only till the 4th digit and after that there is only 0. 

For 1 product it's not a problem, but I've faced to the big problem that due to this issue I have divergence between TOTAL, fact and TOTAL, scenario in $4 even without starting modeling. 

What I have to do and is it even possible to fix?

Any help will be appreciated. Thanks

[v-cherch-msft · Accepted solution]

Hi @D3K

You may have a look at this idea. It seems you may try to narrow the parameter range.

Regards,

Cherie

[D3K]

@v-cherch-msft

It seems like I'm not the one 😉 

Thanks!