Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have following expression in my QV document which calculate growth rate over the last year premium. I want to show only the growth rate which is less than 0 value. Pls help me to modify the following expression to suit my requirement.
(sum({$<PERIODID = {"<=$(=Max(PERIODID))"},YEAR ={$(=Max(YEAR))},QUARTER =,MONTH =,PERIOD =>}[PREMIUM])
-sum({$<PERIODID = {"<=$(=Max(PERIODID)-12)"},YEAR ={$(=Max(YEAR)-1)},QUARTER =,MONTH =,PERIOD =>}[PREMIUM]))
/Fabs(sum({$<PERIODID = {"<=$(=Max(PERIODID)-12)"},YEAR ={$(=Max(YEAR)-1)},QUARTER =,MONTH =,PERIOD =>}[PREMIUM]))*100
if(
(sum({$<PERIODID = {"<=$(=Max(PERIODID))"},YEAR ={$(=Max(YEAR))},QUARTER =,MONTH =,PERIOD =>}[PREMIUM])
-sum({$<PERIODID = {"<=$(=Max(PERIODID)-12)"},YEAR ={$(=Max(YEAR)-1)},QUARTER =,MONTH =,PERIOD =>}[PREMIUM]))
/Fabs(sum({$<PERIODID = {"<=$(=Max(PERIODID)-12)"},YEAR ={$(=Max(YEAR)-1)},QUARTER =,MONTH =,PERIOD =>}[PREMIUM]))*100<0,
(sum({$<PERIODID = {"<=$(=Max(PERIODID))"},YEAR ={$(=Max(YEAR))},QUARTER =,MONTH =,PERIOD =>}[PREMIUM])
-sum({$<PERIODID = {"<=$(=Max(PERIODID)-12)"},YEAR ={$(=Max(YEAR)-1)},QUARTER =,MONTH =,PERIOD =>}[PREMIUM]))
/Fabs(sum({$<PERIODID = {"<=$(=Max(PERIODID)-12)"},YEAR ={$(=Max(YEAR)-1)},QUARTER =,MONTH =,PERIOD =>}[PREMIUM]))*100
)
if(
(sum({$<PERIODID = {"<=$(=Max(PERIODID))"},YEAR ={$(=Max(YEAR))},QUARTER =,MONTH =,PERIOD =>}[PREMIUM])
-sum({$<PERIODID = {"<=$(=Max(PERIODID)-12)"},YEAR ={$(=Max(YEAR)-1)},QUARTER =,MONTH =,PERIOD =>}[PREMIUM]))
/Fabs(sum({$<PERIODID = {"<=$(=Max(PERIODID)-12)"},YEAR ={$(=Max(YEAR)-1)},QUARTER =,MONTH =,PERIOD =>}[PREMIUM]))*100<0,
(sum({$<PERIODID = {"<=$(=Max(PERIODID))"},YEAR ={$(=Max(YEAR))},QUARTER =,MONTH =,PERIOD =>}[PREMIUM])
-sum({$<PERIODID = {"<=$(=Max(PERIODID)-12)"},YEAR ={$(=Max(YEAR)-1)},QUARTER =,MONTH =,PERIOD =>}[PREMIUM]))
/Fabs(sum({$<PERIODID = {"<=$(=Max(PERIODID)-12)"},YEAR ={$(=Max(YEAR)-1)},QUARTER =,MONTH =,PERIOD =>}[PREMIUM]))*100
)