Expression

[upaliwije]

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

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

[upaliwije]

Sorry

I have no idea about that function. Pls show an example

[PrashantSangle]

Hi,

If possible upload sample apps.

Regards

[#4]

Try this

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

[jagan]

Hi,

For selected Year use this variable

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

For previous Year use this variable

vActualPreviousYear = sum({$<Year={$(=Max(Year) - 1)}, DESCRIPTION={'GROSS_PREMIUM'}>}ACTUAL)

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi,

If you want the apply the same for Sum(ACTUAL) then use below

Sum(ACTUAL) / sum({$<DESCRIPTION={'GROSS_PREMIUM'}>}ACTUAL)

For previous Year use this

Sum({$<Year={$(=Max(Year) - 1)}>}ACTUAL) / sum({$<Year={$(=Max(Year) - 1)}, DESCRIPTION={'GROSS_PREMIUM'}>}ACTUAL)

Hope this helps you.

Regards,

Jagan.

[upaliwije]

Thanks Jagan

It is ok. Cant I keep the variable as it is edit the expression to suit the year

[jagan]

Hi,

If you are selecting year by default then this will give you the selected year value.

Sum(ACTUAL) / sum({$<DESCRIPTION={'GROSS_PREMIUM'}>}ACTUAL)

If you are not selecting the year and you want the latest year then use below expression

Sum(ACTUAL) / sum({$<DESCRIPTION={'GROSS_PREMIUM'}, Year={$(=Max(Year) - 1)}>}ACTUAL)

Hope this helps you.

Regards,

jagan.