Set Analysis expression

[imhappiee]

Guys,

Can somebody help me out converting this if condition to a set analysis expression

=if(sum(DISTINCT{$<Flag={'S'},FiscalYear={$(=vMaxYear-1)},FiscalQuarter={'Q1'}>}SVPL_amount)>0 and sum(DISTINCT{$<Flag={'H'},FiscalYear={$(=vMaxYear-1)},FiscalQuarter={'Q1'}>}HWPL_amount)<=0,

0.01,if(sum(DISTINCT{$<Flag={'S'},FiscalYear={$(=vMaxYear-1)},FiscalQuarter={'Q1'}>}SVPL_amount)<=0 and sum(DISTINCT{$<Flag={'H'},FiscalYear={$(=vMaxYear-1)},FiscalQuarter={'Q1'}>}HWPL_amount)<=0,0,

(sum(DISTINCT{$<Flag={'S'},FiscalYear={$(=vMaxYear-1)},FiscalQuarter={'Q1'}>}SVPL_amount)/sum(DISTINCT{$<Flag={'H'},FiscalYear={$(=vMaxYear-1)},FiscalQuarter={'Q1'}>}HWPL_amount)/100)))

Thanks In Advance

Kind Regards,

Happy

[Gysbert_Wassenaar]

That's not possible. A set analysis expression cannot branch like an if statement.