Sales till date

[Vaibhav_Tyagi]

Hi,

I have the date as in Posting_Date in format "DD-MM-YYYY".

I want to get sales of Year 2021 till date and previous Year but when I do so I get 0 value, (Maybe LHS != RHS)

Sum({$<Posting_Dates={">=$(=Max(AddYears(Posting_Dates)))"}>}Net_Sales_After_Discount)

No hardcode , so that data gets self Uploaded.

Should I Change format or declare variables or use If condition. Please Suggest.

Thanks,