stuck with the set analysis grouping and if else logic

[#1]

To calculate Renew Measure consider below columns and if(Renew=1 then sum(EXP_GRS_ANN)) ) Div Bussiness Final Eff_Dt To calculate New Measure consider below columns and if(New=1 ,then sum(REN_GRS_ANN)) ) Div Bussiness Final Eff_Dt.

Please look into source and help on logic

To calculate Renew Measure consider below columns and if(Renew=1 then sum(EXP_GRS_ANN)) )

Div

Bussiness

Final

Eff_Dt

To calculate New Measure consider below columns and if(New=1 ,then sum(REN_GRS_ANN))

)

Div

Bussiness

Final

Eff_Dt

[tresesco]

PFA

[fvelascog72]

Hi,

Try:

For Renew: sum({<RENEW={1}>}EXP_GRS_ANN)

For New: sum({<NEW={1}>}REN_GRS_ANN)

[#4]

The expression you provided is in set analysis but the thing in straight table i have a number of measure are there which are using conditional logic to display the data.can you please look into how to do in if else logic to get the results

[tresesco]

Sorry, not getting your point.

[#6]

While trying with in Deatil Report the expressions are giving Null values(no result).Is it possible to use Aggr function to group by with Div,Bussiness,Final,Eff_Dt