
Re: Percentage growth in chart
Sunny Talwar Sep 28, 2017 7:47 AM (in response to Max Ålander)May be this
(Sum(Value)/Above(Sum({<Week>}Value))  1) * Avg(1)

Re: Percentage growth in chart
Max Ålander Sep 28, 2017 7:50 AM (in response to Sunny Talwar )You made quick work of it!
The following solution works perfect!
Sum(Value)/Above(Sum({<Week>}Value))  1

Re: Percentage growth in chart
UPALI WIJERATNE Sep 28, 2017 9:03 AM (in response to Sunny Talwar )Dear Sunny
(Sum(Value)/Above(Sum({<Week>}Value))  1) * Avg(1)
how does 1 work in this expression. pls explain

Re: Percentage growth in chart
Pratyush Shastri Sep 28, 2017 9:26 AM (in response to UPALI WIJERATNE)Hi Upali
Since you want to compare the current value with the previous one, using fractions the above expression would turn out to be:
(Sum(Value)/Above(Sum({<Week>}Value))  1) * Avg(1)
=(Sum(Value)Above(Sum({<Week>}Value)))/Above(Sum({<Week>}Value)) * Avg(1)
(Sum(Value)Above(Sum({<Week>}Value))) denotes > Current  Previous
Above(Sum({<Week>}Value)) denotes > Previous
Regards
Pratyush

Re: Percentage growth in chart
Sunny Talwar Sep 28, 2017 9:30 AM (in response to UPALI WIJERATNE)You calculate growth like this, right
(ThisPrevious)/Previous
If I expand the equation... it will look like this
This/Previous  Previous/Previous
Which is nothing but this
This/Previous  1



Re: Percentage growth in chart
Pratyush Shastri Sep 28, 2017 7:46 AM (in response to Max Ålander)PFA the app for your reference.
RegardsPratyush

Test.qvw 148.5 K
