Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
That's not possible. A set analysis expression cannot branch like an if statement.