SUM IF with AGGREGATE Function

[Anonymous]

Hello - I am new to Qlik and need to do a IF and aggregate function. Is this possible?

This is what I have but get an ERROR:

SUM(IF(Status= 'Eligible',IF(Status= 'Out Of Contract',(SUM(Revenue)/COUNT(member_id)))))

Thanks!

[vishsaggi]

Are you looking for this? If not can you elaborate a little more please on what exactly you are trying to calculate.

= IF(Status= 'Eligible', Sum({< Status= {'Out Of Contract'} >} Revenue)/COUNT(member_id))