Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following table and I want to calculate the percentage of total cost per kg. I have 2 master measures that I created and I would want to divide 1 by the other - I thought the purpose of creating master measures was for them to be reused. How can I do this without having to recreate the measures in a new measure?
I wanted to calc the % by taking Cost per kg/ Total Cost per kg.
(some of the Weights are missing in data, hence check for length in my measure calc).
The following are my master measures:
Cost per kg = Sum(If(len(trim([Chargeable Weight]))>0,[Total Invoice Amount]/[Chargeable Weight],[Total Invoice Amount]))
Total Cost per kg = Sum(TOTAL([Total Invoice Amount]/[Chargeable Weight]))
You can use column() function if you want to see the result in the same table as master measuers. In your case it should be column(4)/column(6).
BR,
Maria
You can use column() function if you want to see the result in the same table as master measuers. In your case it should be column(4)/column(6).
BR,
Maria
Thank you Maria - that worked perfectly! Is there a way to calculate that without having to show the Total Cost per kg measure in the table? I really don't want to show that field but it appears I cannot reference it if it isnt in the table.
Actually I do not know about this possibility .