Growth

[upaliwije]

HI Friends

I have created the following Pivot table where Ach % and Growth % need to be calculated

YEAR	2013	2014	2015
GROSS_PREMIUM	645,137,085	707,202,807	251,743,928
ACH %	78	90	89
GROWTH %	-	-	-

my expression for calculation of Growth is as follows but the result is not calculated. Pls see whether there is any error in the expression

YEAR is a dimension field

(sum( {$<DESCRIPTION = {GROSS_PREMIUM},YEAR = {"$(=Only([YEAR]))"}>} [ACTUAL] )

-sum( {$<DESCRIPTION = {GROSS_PREMIUM},YEAR = {"$(=Only([YEAR]-1))"}>} [ACTUAL] ))

/Fabs(sum( {$<DESCRIPTION = {GROSS_PREMIUM},YEAR = {"$(=Only([YEAR]-1))"}>} [ACTUAL] ))*100

[#2]

Try like this for growth:

(((sum( {$<DESCRIPTION = {GROSS_PREMIUM},YEAR = {"$(=Only([YEAR]))"}>} [ACTUAL] ))

/(Fabs(sum( {$<DESCRIPTION = {GROSS_PREMIUM},YEAR = {"$(=Only([YEAR]-1))"}>} [ACTUAL] ))))-1)*100

If still not working can u share qvw for above.

Thanks

Khushboo

[tresesco]

Is DESCRIPTION a field and 'GROSS_PREMIUM' is a field value to it? If so, put the string within single quotes like:

sum( {$<DESCRIPTION = {'GROSS_PREMIUM'},..

[#4]

Try this:

(sum(<{description= {gross_premium}, Year={"$(=Only([YEAR]))"}  }> [Actual]) /

sum(<{description= {gross_premium}, Year={"$(=Only([YEAR]-1))"}  }> [Actual]))-1

[er_mohit]

Hi

Try this

(sum( {$<DESCRIPTION = {'GROSS_PREMIUM'},YEAR = {'=$(=max([YEAR]))'}>} [ACTUAL] )

-sum( {$<DESCRIPTION = {'GROSS_PREMIUM'},YEAR = {'=$(=max([YEAR])-1)'}>} [ACTUAL] ))

/

Fabs(sum( {$<DESCRIPTION = {GROSS_PREMIUM},YEAR = {'=$(=max([YEAR])-1)'}>} [ACTUAL] ))*100

[upaliwije]

Now the output is like this

GROSS_PREMIUM	298,965,722	292,783,955	348,247,713	372,504,375
ACH %	92	84	105	90
GROWTH	0.00	0.00	0.00	0.00

[tresesco]

I guess you could help us help you by sharing your qvw with sample data.