Hello All,
I have written a expression with plenty of IF conditions in it and it is doing the purpose, but when I look it I personal feel that it can be written in more optimize way
Kindly suggest me how can I write the below expression in more optimize way instead of IF conditions
if(SubStringCount([Measure for Filter],'ABSRPT'),
if('$(vComparison)'='8', sum([Impact]),
if(vComparison=1,
if(Num(sum([ABSRPT]), '#,##0.##', '.' , ',' )=Num($(vThresholdValue), '#,##0.##', '.' , ',' ),sum([Impact])),
if(vComparison=2,
if(sum([ABSRPT])<>$(vThresholdValue),sum([Impact])),
if(vComparison=3,
if(sum([ABSRPT])>$(vThresholdValue),sum([Impact])),
if(vComparison=4,
if(sum([ABSRPT])>=$(vThresholdValue),sum([Impact])),
if(vComparison=5,
if(sum([ABSRPT])<$(vThresholdValue),sum([Impact])),
if(vComparison=6,
if(sum([ABSRPT])<=$(vThresholdValue),sum([Impact]))
)))))))
Note: Copying only a piece of lines from my 143 line expression hoping that if i fix this i can fix the rest tooo
Thanks
