Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I need to calculate tax return after each month which would be a difference between purchase tax as a new dimension e.g. TaxReturnAmount so that in the following example I'd get 2 in February and -1 in March.
Month, Side, TaxAmount
Jan, Sales, 8
Jan, Purchase, 10
Feb, Sales, 5
Feb, Purchase, 4
Any idea how to calculate it?
BR,
Przemek
It looks like an if statement would work.
= sum(if(Side='Sales',-Taxamount,Taxamount))
Ben, thanks your reply. The key thing in this exercise is to move the result to next month. In your statement it stays in the original one.
BR,
Przemek