Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Day
Can some one help me with a formula that will take the total amount of the netprofit for the first month and then take the total netprofit of the second month find the difference.
So basically if:
Jan = 10
Feb = 11
Mar = 5
then the difference between Jan and feb is 1 so Feb will = 1
and then the difference between Feb and Mar is 4 so Mar will = 4
and so on.
Thank you
Stuart
Perhaps sum(amount)-above(sum(amount)).
One option is to do it like this:
=RangeSum(Sum(NetProfit), -Above([Exp]))
Where Exp is the expression label
Temp:
Load * Inline [
Month, Amount
Jan, 10
Feb, 11
Mar, 5
];
Final:
Load *,
if(Amount-previous(Amount) > 0, Amount-previous(Amount), -(Amount-previous(Amount))) as difference
resident Temp;
Drop table Temp;