Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ...
for ex I have 2000 as rent cost and 200 as non-rent cost.I want to calculate the Rent cost as % of non-rent cost.
How can I put the logic here ?Thanks much.
Hi!
expression: [rent cost]*100/[non-rent cost]
for your example: 2000*100/200 = 1000 %
May be add Type of cost as your second dimension and use an expression like this:
Sum(Cost)/Sum(TOTAL <Dimesion1> Cost)