Expression

[upaliwije]

Sum(ACTUAL)/({$<YEAR = {$(=Max(YEAR))}>}$(=$(=vActual))*100)

The above expression is not working. Pls help me to correct it

[PrashantSangle]

Hi,

Try like

Sum(ACTUAL)/({$<YEAR = {"$(=Max(YEAR))"}>} $(vActual))*100)

Regards,

[jonathandienst]

Hi

Not sure what you are trying to achieve, but you are missing an aggregation function (Min, Mx, Sum, Count etc) here:

                              V

Sum(ACTUAL) /   ({$<YEAR = {$(....

HTH

Jonathan

[upaliwije]

Not working please

[upaliwije]

What I am Trying to achieve is to calculate a ratio where $(vActual) is variable. That variable I want to apply to a particular that is selected by user

[PrashantSangle]

Hi,

my bad

try this,

Sum(ACTUAL)/Sum({$<YEAR = {"$(=Max(YEAR))"}>} $(vActual))*100)

or

Sum(ACTUAL)/Sum({$<YEAR = {"$(=Max(YEAR))"}>} vActual)*100)

Regards

[jonathandienst]

Have you tried this?

Sum(ACTUAL) / vActual * 100

[upaliwije]

That is working. But I want to specify Selected year and and in another expression Year-1

[upaliwije]

Still not working

my vActual variable=sum({$<DESCRIPTION={'GROSS_PREMIUM'}>}ACTUAL)

[its_anandrjs]

Then please use GetfieldSelections() function with field name will help you better.