Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
PFA
Hi,
Try:
For Renew: sum({<RENEW={1}>}EXP_GRS_ANN)
For New: sum({<NEW={1}>}REN_GRS_ANN)
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
Sorry, not getting your point.
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