Convert to set analysis

[#1]

Hello guys,

I have the following expression

SUM(IF(YEAR(OrderBacklogContractedPostingDate)=YEAR(CYear) AND MONTH(OrderBacklogContractedPostingDate)>MONTH(MAX(CDate))
       ,IF(ISNULL(OrderBacklogContractedAmount) OR OrderBacklogContractedAmount=''
           ,0
           ,OrderBacklogContractedAmount)))

How to change this to set analysis?

Thank you for your kind attention guys

[jagan]

Hi,

Try like this,  arrive Year dimension in script for OrderBacklogContractedPostingDate and CYear, and Month dimension for OrderBacklogContractedPostingDate

Now in set analysis try this

=SUM({<OrderBacklogContractedPostingDate_Year)= P(CYear_Year), OrderBacklogContractedPostingDate_Month = {'>$(=MONTH(MAX(CDate)))'}>}
       Alt(OrderBacklogContractedAmount, 0))

Replace OrderBacklogContractedPostingDate_Year, CYear_Year and OrderBacklogContractedPostingDate_Month with your new fields arrived in script.

Regards,

Jagan.