
Not applicable
2016-05-09
07:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Net Profit Calculation
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
626 Views
3 Replies

Partner - Champion III
2016-05-09
11:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Perhaps sum(amount)-above(sum(amount)).
talk is cheap, supply exceeds demand
554 Views

MVP
2016-05-09
04:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
One option is to do it like this:
=RangeSum(Sum(NetProfit), -Above([Exp]))
Where Exp is the expression label
554 Views

Not applicable
2016-05-09
04:41 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;
