How i can Write This expression With out If Statement!!!

[#1]

Hi

  I want write Below expression with using if Condition in set expression

   Please can one help me on this

if(FcstALMeFW='Rem. Fcst.' or FcstALMeFW='Rem. Fcst.w/o Judge',sum({<FiscalYearQuarter=,MeasureType={'FFYR'},SubRegion=>} CommitAmount))

Thanks

Manju

[sagarkharpude]

Without If condition:

=sum({<MeasureType={'FFYR'},FcstALMeFW={'Rem. Fcst.','Rem. Fcst.w/o Judge'},SubRegion=FiscalYearQuarter=>} CommitAmount)

With if condition

=sum(if(FcstALMeFW='Rem. Fcst.' or FcstALMeFW='Rem. Fcst.w/o Judge',MeasureType='FFYR',CommitAmount))

[#3]

Hi ,

  Thanks For Replay  After applying this I got some Issue please look the out put and let know what is the issue

please look attachment