Need Assistance.

[suvechha_b]

Hi ,

My requirement is  to transform the below expression with set analysis expression

count( DISTINCT if(Deal.typeOfSale <> 'Aftermarket' and ( Deal.bodyInsuranceIncomeTick <> '0' or Deal.compInsuranceIncomeTick <> '0' or Deal.depositCoverIncomeTick <> '0' or Deal.inflationProtectorIncomeTick <> '0' ) , Deal.batch_ref))

Please kindly confirm the correct set analysis expression of the given sample -

I tried this , I am not sure about the 'and' and 'or' condition written correctly

Count(DISTINCT {<Deal.typeOfSale -= {'Aftermarket'} ,Deal.bodyInsuranceIncomeTick-={'0'} , Deal.compInsuranceIncomeTick-={'0'}, Deal.depositCoverIncomeTick-={'0'}, Deal.inflationProtectorIncomeTick-={'0'}>} Deal.batch_ref)

Thanks,

[jaumecf23]

I think you need to use this:

Count(DISTINCT {<Deal.typeOfSale -= {'Aftermarket'} ,Deal.bodyInsuranceIncomeTick-={'0'}>}

+

{<Deal.typeOfSale -= {'Aftermarket'} ,Deal.compInsuranceIncomeTick-={'0'}>}

+

{<Deal.typeOfSale -= {'Aftermarket'} ,Deal.depositCoverIncomeTick-={'0'}>}

+

{<Deal.typeOfSale -= {'Aftermarket'} ,Deal.inflationProtectorIncomeTick-={'0'}>}

Deal.batch_ref)

[PrashantSangle · Accepted solution]

just modifying above expression

Count(DISTINCT {<Deal.typeOfSale -= {'Aftermarket'} ,Deal.bodyInsuranceIncomeTick-={'0'}>

+

<Deal.typeOfSale -= {'Aftermarket'} ,Deal.compInsuranceIncomeTick-={'0'}>

+

<Deal.typeOfSale -= {'Aftermarket'} ,Deal.depositCoverIncomeTick-={'0'}>

+

<Deal.typeOfSale -= {'Aftermarket'} ,Deal.inflationProtectorIncomeTick-={'0'}>}

Deal.batch_ref)

Regards,