topic Re: Net Profit Calculation in QlikView

Net Profit Calculation

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Net Profit Calculation

Gysbert_Wassenaar — Mon, 09 May 2016 15:45:22 GMT

Perhaps sum(amount)-above(sum(amount)).

Re: Net Profit Calculation

sunny_talwar — Mon, 09 May 2016 20:36:33 GMT

One option is to do it like this:

=RangeSum(Sum(NetProfit), -Above([Exp]))

Where Exp is the expression label

Re: Net Profit Calculation

Mon, 09 May 2016 20:41:48 GMT

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;