Forum Discussion

Pedro_Lourenco's avatar
Pedro_Lourenco
Frequent Visitor
6 years ago

Calculated column is showing a wrong result

Hi, I would like to know why the result in the Calculated column is wrong. 

 

As you can see, it's a simple request: Multiply the value of the column "Ações" and the column "Pl".  

But the result is completely wrong! How paper this negative value from a multiplication of two positives??

 

 

FYI: The column Pl is also calculated, Pl = Related(tableB[ColumnX]). With this, I got the valor from table b.

 

 tks

 

Need Help

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Pedro_Lourenco weird, seems like these two columns datatype is number, what is that RS next to PI column, is it a number column?

     

    Just thinking out of the box but it doesn't make sense though. something we are missing here.

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    Hi , Pedro_Lourenco 

    Could you please tell me whether your problem has been solved?
    If it is,  please mark the helpful replies or add your reply as Answered to close this thread.

    It will help other community members easily find the solution when they get the same issue.

     

    Best Regards,
    Community Support Team _ Eason