Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
im struggling to get the following to add together. for the first count expression i get 3 and the other i get 2 if i try them individually. i want them to be added together to show 5
where am i going wrong?
if($(vNBRNL)=2,
count({<RISK_TYPE={'RENEWAL'}, COMP_STATUS={'Incomplete'}>}RISK_ID)+
count({<RISK_TYPE={'BACK_LOADED'}, DUE_TO_RENEW-={'Expired'}>}RISK_ID))
thanks
Hi,
try to put if inside of each expression
count({<RISK_TYPE={'RENEWAL'}, COMP_STATUS={'Incomplete'}>} if($(vNBRNL)=2, RISK_ID))+
count({<RISK_TYPE={'BACK_LOADED'}, DUE_TO_RENEW-={'Expired'}>} if($(vNBRNL)=2, RISK_ID))
Hi,
try to put if inside of each expression
count({<RISK_TYPE={'RENEWAL'}, COMP_STATUS={'Incomplete'}>} if($(vNBRNL)=2, RISK_ID))+
count({<RISK_TYPE={'BACK_LOADED'}, DUE_TO_RENEW-={'Expired'}>} if($(vNBRNL)=2, RISK_ID))