Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Sunny, Once growth rate was calculated normally it shows in 6th column. Since if there was a negative value last Year with positive figure in the current Year, I brought in "fabs" to overcome it but the answer seems to be wrong. Please check the answer of Class M3 , It actually needs to be 475 (positive) but takes 275. Other figures are ok. Expression applied are too summerized below.
=Alt((Sum(GROSS_PREMIUM)-Below(TOTAL Sum(GROSS_PREMIUM), Count(DISTINCT TOTAL <TRN_YEAR> CLASS_CODE)))
/Below(TOTAL Sum( GROSS_PREMIUM), Count(DISTINCT TOTAL <TRN_YEAR>CLASS_CODE))*100, 0)
=Alt((Sum(GROSS_PREMIUM)- fabs( Below(TOTAL Sum(GROSS_PREMIUM), Count(DISTINCT TOTAL <TRN_YEAR> CLASS_CODE))))
/fabs( Below(TOTAL Sum( GROSS_PREMIUM), Count(DISTINCT TOTAL <TRN_YEAR>CLASS_CODE)))*100, 0)
Thanks in advance
Neville
fabs() is probably working fine.
Could you please share your definition of a percentage change when the values to compare are of a potential different sign?
IMO, it will be very hard to define a consistent, unambigous definition.
Would be interested in seeing one.
Dear Stefan,
I have given the formula applied & results just check the class M3, may be the place I have added fabs not correct. If you could refer my 2nd expression with fabs word, you may see here I have gone wrong!
Regards
Neville
Hi Neville, maybe without the first fabs:
=Alt((Sum(GROSS_PREMIUM)- Below(TOTAL Sum(GROSS_PREMIUM), Count(DISTINCT TOTAL <TRN_YEAR> CLASS_CODE)))
/fabs( Below(TOTAL Sum( GROSS_PREMIUM), Count(DISTINCT TOTAL <TRN_YEAR>CLASS_CODE)))*100, 0)
It will compare the total difference with past year value always positive, if you do the firts fabs you are not comparing the total difference between years.