Forum Discussion

Blairena's avatar
Blairena
Regular Visitor
4 years ago

Column Calculate is wrong

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!

 

 

 

 

4 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi Blairena 

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

    • Blairena's avatar
      Blairena
      Regular Visitor
      4 years ago

      Hi Tamerj,

       

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

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        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?