MTD Syntax Error

[Anonymous]

Dear all,

Could you suggest syntax error in following expression:

=num(Sum({<[DATE OF ISSUE]={">=$(=Num(MonthStart(Max([DATE OF ISSUE]))))<=$(=Max([DATE OF ISSUE]))"},COMPANY={'TCIL'}>} SALES)/VMillion,'00')

Regards,

Balraj

[Anonymous]

Harsha,

I have checked but no such scenario.

[#3]

Hi Balraj,

Try with the below expression which is not having COMPANY = {'TCIL'}

=num(Sum({<[DATE OF ISSUE]={">=$(=Num(MonthStart(Max([DATE OF ISSUE]))))<=$(=Max([DATE OF ISSUE]))"}>} SALES)/VMillion,'00')

If it is working fine then the remaining dates are not related with the COMPANY = {'TCIL'}.

Try it and let me know..

Thanks

Harsha

[#4]

Hi,

You can create a variable and pass today()-1

vCurrDate=today()-1 and by pass fiscal year and days,

Sum({$<Day=,Fin_Year=, Date={"<=$(vCurrDate)"}>}Value)

year([DATE OF ISSUE]) as year, day([DATE OF ISSUE]) as day

MTD =num(Sum({<year=,day=,[DATE OF ISSUE]={"<=$(vCurrDate)"}>} SALES)/VMillion,'00')

Regards

Vimlesh