Growth based on rangesum total under each Year

[nevilledhamsiri]

Hi Friends

I need to get the growth rate based on rangesum total.In 2020 we are in the 6 months  so that growth calculation should be for 6Months vs 6 months,

Formula used seems to be not working

SUM(AGGR(RANGESUM(above(SUM(PREMIUM),0,RowNo())),TR_YEAR,TR_MONTH))/above(SUM({<TR_YEAR>}(AGGR(RANGESUM(above(SUM(PREMIUM),0,RowNo())),TR_YEAR,TR_MONTH)))-1)

Any help in this direction!

Thanks

Neville

[Brett_Bleess]

Just doing a response to kick this one back out given you submitted it on a Saturday, not sure a lot of folks likely saw the post.   Unfortunately I am not much help, best I can do is the following Community area link where you might find some examples to help:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

The only other thing I could suggest is to recheck the Help on those functions too in order to be sure syntax is correct etc., but it might also help to break the expression down and put those components into text objects to see what you are getting back, as that may help narrow down where things are going wrong too, coworker taught me that trick years ago.  Sorry I am not more help.

Regards,
Brett