Set Analysis Sum with if condition

[mario-sarkis]

Hey

here is my question

How can i write this into a set analysis

if(Type='990' or Type ='sfb' or Type='sfd',Sum(Amount)/Count(trx),Sum(Amount)

how can i write this into a set analysis.

Thanks

[mario-sarkis · Accepted solution]

Thanks it works like this

if(Type='990',Sum(Amount)/Count(trx),

             if(Type ='sfb' ,Sum(Amount)/Count(trx),

                   if(Type ='sfd' ,Sum(Amount)/Count(trx),Sum(Amount)

[sunny_talwar]

Can be simplified like this:

If(Match(Type, '990', 'sfb', 'sfd'), Sum(Amount)/Count(trx), Sum(Amount))