I am required to create measures to convert revenue and cost to a $/Qty.
My issue is that some Credits do not have a quantity. This is my formula for Net Price per Tonne:
Net Price per Tonne =
IFERROR([Net Revenue]/[Total Tonnes],BLANK())
This is my result:
At the lowest level it’s doing what i’d like, but at the total customer level it’s not. At a customer level it’s not taking the total value of the credits and dividing it by the total tonnes (the reason for some zero quantities is quality credits, so no qty returned, the credits only effect the price).
Any ideas how i can get around this? Do i need to base my measures on a single context or should i be able to apply them to multiple contexts?