What is wrong in expression

[qlik4asif]

Hi All,

please help me in the below expression

=Num(Sum({<Function={'Seeds Ops'},DateMonth={Date(Addmonths(vMaxDate_IIR,-12),'YYYY-MM')}>}YTD),'##.00')

[qlik4asif]

Hi Sunny,

Could you please find the error for the below expression

=Num(Sum({<DateMonth={">=$(=Yearstart(vMaxDate_E2E_Seeds_ProductionCost))<=$(=YearEnd(vMaxDate_E2E_Seeds_ProductionCost))"}>}BUD),'##.###')

[Anil_Babu_Samineni]

May be

=Num(Sum({<DateMonth={">=$(=Yearstart($(vMaxDate_E2E_Seeds_ProductionCost)))<=$(=YearEnd($(vMaxDate_E2E_Seeds_ProductionCost)))"}>}BUD),'##.###')

[qlik4asif]

Thanks Anil for the reply

But its not working

[Anil_Babu_Samineni]

May be with equal sign

=Num(Sum({<DateMonth={">=$(=Yearstart($(=vMaxDate_E2E_Seeds_ProductionCost)))<=$(=YearEnd($(=vMaxDate_E2E_Seeds_ProductionCost)))"}>}BUD),'##.###')

can you describe how you define the variables if none of them working

[shraddha_g]

Try

Num(Sum({<DateMonth={">=$(=Date(Yearstart($(vMaxDate_E2E_Seeds_ProductionCost)),'YYYY-MM'))<=$(=date(YearEnd($(vMaxDate_E2E_Seeds_ProductionCost)),'YYYY-MM'))"}>}BUD),'##.###')

[sunny_talwar]

Or this

=Num(Sum({<DateMonth = {">=$(=Date(Yearstart(vMaxDate_E2E_Seeds_ProductionCost), 'YYYY-MM'))<=$(=Date(YearEnd(vMaxDate_E2E_Seeds_ProductionCost), 'YYYY-MM'))"}>}BUD), '##.###')