Expression Help

[abhaysingh]

Last 3 Days sale for two year....

how can i do this?

[tresesco]

Always come back(after posting) and try to see your post from others' (who know nothing about your app or requirement beyond the words you wrote) point-of-view to check if you can make out something meaningful out of that. If not, you might have to be more expressive in your question.

[abhaysingh]

HI TRESESCO

WHAT I WANT IS LIKE FOR YEAR 2014,

Ex in April 2014 last three days Sale april,

in may 2014 last three days sale of may and so on for rest of the month.

is it possible? if yes than what is the expression?

[#4]

hi abhay,

use daystart() and dayend() function!

regards,

Barathiraja

[tresesco]

Assuming you are selecting a date/month to get last three day sales. Try expression like:

Sum({<Date={">$(=Date(Max(Date)-3)) <=$(=Date(Max(Date)))"}>}Sales)

[PradeepReddy]

sales in last 3 days of the month...

Sum({<Datefield ={">=$(=date(Monthend(Datefield)-2)) <=$(=date(Monthend(Datefield)))"}>}Sales)

[#7]

Couldn't agree more