sum two count set expressions together

[david_pearson]

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 

[StarinieriG · Accepted solution]

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))