Forum Discussion
pokarman
6 years agoFrequent Visitor
how to multiply column with measure
In the above snip i am trying to multiply GR QTY column with measure actualval and displaying result in other measure Actualvalsaleafterpercentage but i m calcuating same value in calculator...
Greg_Deckler
6 years agoCommunity Champion
Is it possible that your actualVal measure has more decimal places than you are showing? For example, if the actualVal in your first row is actually 1.441990384 then that would explain it.
pokarman
6 years agoFrequent Visitor
Greg_Deckler Hello Greg ,
I am showing exact 2 decimal places but still result is not showing correct.
- Greg_Deckler6 years agoCommunity Champion
OK, and I don't mean to needle but did you try increasing how many decimal places are shown by using the formatting ribbon? I have to ask to be sure because it's the only thing that makes sense.