Forum Discussion

Dhjlm's avatar
Dhjlm
Frequent Visitor
4 years ago

Need help with calculation

I have this problem giving me gray hair. So I have customer no, sales, cost and cost of sales %. The cost of sales % is correct for each customer no, but the total is wrong. I would like it to be ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Dhjlm , will measure like that help ?

divide(Sum(Table[Cost]), Sum(Table[Sales]) )

  • Dhjlm's avatar
    Dhjlm
    Frequent Visitor
    4 years ago

    Sorry, that didn´t help