%change of price and %change of quantity

[voetpad]

Is it in Transformer possible to create a measure which uses this function:
((new quantity - old quantity)/old quantity *100%) / ((New price - old price)/old price *100%)

New price and new quantity are known in the current period and old price and old quantity are known in the previous period.

I can only calculate the quantity change or the price chance. But not both at the same time.

 

[tigger127]

Hey,
Could you please explain how you made the calculation for the quantity change or the price change?
It would help me, since I need to make similar calculations and I don't know how to do so with power play.

Thnx.