Set Analysis

[#1]

Can anyone please help me find out what is wrong with this expression

Sum({1}(If(mixmatch(FCRProduct,'Pegasys','Transplant','Nutropin','Lytics'), Aggr(max(TerrCount),FCRProduct))))

[jagan]

Hi Swati,

Try like this

=Sum({1}Aggr(If(mixmatch(FCRProduct,'Pegasys','Transplant','Nutropin','Lytics'), max(TerrCount)),FCRProduct))

Regards,

Jagan.

[Anonymous]

Hi,

Try below,

Sum({1} Aggr(Max(If(MixMatch(FCRProduct,'Pegasys','Transplant','Nutropin','Lytics'), TerrCount)), FCRProduct))