Column Calculate is wrong

[Blairena]

Hello, 

I need to calculate A/B*C*D, and all the calculated amount in excel is right when I download the form from Power BI to check the result. 

Below is my fomula and the Values of A, B, C, D is all conrect but I don't know why the result in this column is not right.

The Var as below but it should not be decimal point issue. 

Hope there can has someone to solve my problem, apprecaited it!

[tamerj1]

Hi @Blairena 

Would you please add brackets to A/B*C*D to clarify your desired result?

[Blairena]

Hi Tamerj,

Here is my desired result, (A/B)*C*D. 

[tamerj1]

@Blairena 

Then your formula is correct. I have no idea why you're getting wrong numbers! you are creating a calculated coulmn, right? And all all of them are coulmns? No measures?

[Blairena]

@tamerj1 

Hi,

I have separated the formula, and founded that A/B is correct, and when it comes to (A/B)*C, the result shows wrong, C column formula as below. 

Actually all the columns has formula, but I just founded that the wrong result comes here and don't know why.