Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Vaibhav_Tyagi
Contributor
Contributor

Sales till date

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,

0 Replies