Hello Experts,
The below nested if condition with sum in the script consumes a long time for reload.
SUM( (IF(GROUP_CATEGORY='G:Contributions_PMA',ACTIVITY,0)+
IF(GROUP_CATEGORY='C:Contributions Transferred',ACTIVITY,0)+
IF(GROUP_CATEGORY='C:Contributions Reinvested',ACTIVITY,0)+
IF(GROUP_CATEGORY='G:Distributions Income',ACTIVITY,0)+
IF(GROUP_CATEGORY='G:Distributions Capital',ACTIVITY,0)+
IF(GROUP_CATEGORY='G:Distributions Realized Gains',ACTIVITY,0) +
IF(GROUP_CATEGORY='C:Distributions Redemption' OR
GROUP_CATEGORY='C:Redemptions Adjustments', ACTIVITY,0)+
IF(GROUP_CATEGORY='C:Redemptions Transferred', ACTIVITY,0)+
IF(GROUP_CATEGORY='G:NII_PMA', ACTIVITY,0)+
IF(GROUP_CATEGORY='G:Realized Gain Loss' OR
GROUP_CATEGORY='C:H_Unrealized Gain Loss Equity Side',ACTIVITY,0) +
IF(GROUP_CATEGORY='C:Reverse Unrealized', ACTIVITY,0) +
IF(GROUP_CATEGORY='C:Property Appreciation' OR
GROUP_CATEGORY='C:H_APRADJI' OR
GROUP_CATEGORY='C:H_Unealized Gain Loss Equity Side' OR
GROUP_CATEGORY='G:MI Valuation' OR
GROUP_CATEGORY='C:H_Investment Appreciation OLD' , ACTIVITY,0)+
IF(GROUP_CATEGORY='C:Unrealized Gain Loss Incentive Fee', ACTIVITY,0)+
IF(GROUP_CATEGORY='C:Appreciation FX Property', ACTIVITY,0) +
IF(GROUP_CATEGORY='C:Unrealized Gain Loss FX Fund' OR
GROUP_CATEGORY='C:H_Investment Appreciation', ACTIVITY,0) +
IF(GROUP_CATEGORY='G:Syndication Costs Derivatives', ACTIVITY,0) +
IF(GROUP_CATEGORY='C:Offering Costs', ACTIVITY,0)+
IF(GROUP_CATEGORY='G:GIPS Only Appreciation', ACTIVITY,0))*(-1)) AS Price_NAV_1
Can you please suggest the alternative way for the same.
Thanks