Issue in expression- last year MTD

[Anonymous]

Hi Friends

I am using below expression to get last year MTD.

Example , if today is 10th, then we should get Oct 1st 2017 to 10th 2017. However using below expression is giving me 0.

sum( {<Year=,Month=,Date={">=$(=AddYears(MonthStart(max(Date)),-1)) <=$(=AddYears(max(Date),-1))"} >}   SALES)

Kindly help to resolve the issue in above expression.

Thanks & Regards

Chintan Gala

[MindaugasBacius]

Then simply check if it works with either one switch between:

1. =Date(AddYears(MonthStart(Today()), -1), 'YYYY.MM.DD')

2. =Date(AddYears(Today(), -1), 'YYYY.MM.DD')

Check if the Date and SALES fields are named the same in the script.

Check if Date formatting is correct 'YYYY.MM.DD'.

Simple play & debug the sentence till you understand what's wrong.