Expression

[upaliwije]

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

[gautik92 · Accepted solution]

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

)