Allocated memory exceeded

pashok75 — Thu, 12 Apr 2018 06:44:26 GMT

I am trying to take an average based on a variable field. When I do that I am getting an error Allocated Memory Exceeded.

The Expression is

(SUM($(vPremiumYTD))) / Sum(TOTAL $(vPremiumYTD))*100

The variable $(vPremiumYTD) is

if(GetFieldSelections(PREMIUM_FLAG) = 'AP' or GetSelectedCount(PREMIUM_FLAG)<>1

, (sum(if(T_APPR_DT <= AddYears(max(total T_APPR_DT), T_YEAR - Year(max(total T_APPR_DT))), T_NETPREM)))/vNumber

, if(GetFieldSelections(PREMIUM_FLAG) = 'ER' and GetSelectedCount(PREMIUM_FLAG)=1 ,

(sum(if(T_APPR_DT <= AddYears(max(total T_APPR_DT), T_YEAR - Year(max(total T_APPR_DT))), T_ER_PREM)))/vNumber

))

Re: Allocated memory exceeded

d_pranskus — Thu, 12 Apr 2018 07:41:47 GMT

Using IF function inside the Aggregation function (like SUM) is a bad practice. You need to refactor your expression to use set analysis instead.

It should look something like this:

IF(ONLY(PREMIUM_FLAG) = 'AP,

SUM({<T_YEAR = {$(=MAX(T_YEAR))}, T_APPR_DT = {"<=$(=DATE(MAX(T_APPR_DT)))"}>} T_NETPREM),

IF(ONLY(PREMIUM_FLAG = 'ER',

SUM({<T_YEAR = {$(=MAX(T_YEAR))}, T_APPR_DT = {"<=$(=DATE(MAX(T_APPR_DT)))"}>} T_ER_PREM)

))

Basically I am filtering in set analysis on the cuirrtent year and then filtering on the date to be less than max date.