sum two count set expressions together

david_pearson — Thu, 07 Nov 2019 16:08:00 GMT

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

Re: sum two count set expressions together

StarinieriG — Thu, 07 Nov 2019 16:22:56 GMT

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

topic Re: sum two count set expressions together in Water Cooler

sum two count set expressions together

Re: sum two count set expressions together