Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Actually ,i need to show 10% increase of Sales by Month which depend on 2019 sales as below
The calculation of budget 2019 is
Jan-48566
Feb-(48566*10)/100+48566=58764
March-(58764*10)/100+58764=64641.35
Two options
1)
If(RowNo() = 1, Sum(Sales), Above([10% Budget]) * 1.1)
2)
Exp(RangeSum(Above(log(1.1), 1, RowNo()))) * Sum(TOTAL {<Month = {'Jan'}>} Sales)
Basically, we are doing like this
Jan - 1 Feb - 1.1 Mar - 1.1 * 1.1 Apr - 1.1 * 1.1 * 1.1
So, in order to accumulated multiplication, I am using Log function which can then be added and then brought back to its original form using exp() function.
Like this?
No its note like that.
It would considered 10 % increase over previous record.
Regards,
Ali
Thanks for your help.
But it would not fulfill my requirement as calculation is based on Initial values e.g
10 % Increase over MONTH
Month | Sales | 10 % Budget---This is result |
Jan | 100 | 110 |
Feb | 82 | 120 |
Mar | 120 | 130 |
@sunny_talwar -Could you please help me for above requirement
@alis2063 wrote:
Month Sales 10 % Budget---This is result Jan 100 110 Feb 82 120 Mar 120 130
How are you getting 10% Budget column in this example? 110 seems to be 100 * 1.1, but how is 120 and 130 getting calculated here?
Sorry for Jan Month it would be same & calculation would be just as below
Month | Sales | 10 % Budget---This is result |
Jan | 100 | 100 |
Feb | 82 | 110=(100*10)/100+100 |
Mar | 120 | 121=(110*10)/100+110 |
Two options
1)
If(RowNo() = 1, Sum(Sales), Above([10% Budget]) * 1.1)
2)
Exp(RangeSum(Above(log(1.1), 1, RowNo()))) * Sum(TOTAL {<Month = {'Jan'}>} Sales)
Thanks Sunny
you are awesome man!!!