Sum Date range

[Anonymous]

Hello,

I want to sum up to today -1 but in the example bellow I'm getting 0.

i'm trying:

=sum({$<S_Date={'>=$(=Date(min(S_Date)))<=$(=Date(today()-1)))'}>}Sales_limit)

sum from 16/05 to 23/05.

how can I do that?

Tks

S_Date	Sales_limit
16/05/2018	10
17/05/2018	20
18/05/2018	30
19/05/2018	40
20/05/2018	50
21/05/2018	60
22/05/2018	70
23/05/2018	80
24/05/2018	90
25/05/2018	100
26/05/2018	110
27/05/2018	120
28/05/2018	130
29/05/2018	140
30/05/2018	150

[pradosh_thakur]

Your field must be a date

=sum({$<S_Date={">=$(=Date(min(S_Date)))<=$(=Date(today()-1)))"}>}Sales_limit)

[jonathandienst]

Try this:

=Sum({<S_Date = {">='$(=Date(min(S_Date)))' <='$(=Date(today()-1))'"}>} Sales_limit)

[Anonymous]

which field? could you give an example please?

tks

[Anonymous]

tried but no success.

Follow the qvw.

tks

[PrashantSangle]

as jonathan suggested try with " (double quote).

It will work.

Regards,

[Anonymous]

tried but no success.

[PrashantSangle · Accepted solution]

bro you have extra closing in set analysis check

try below

sum({$<S_Date={">=$(=Date(min(S_Date)))<=$(=Date(Today()-1))"}>}Sales_limit)

Regards,

[Anonymous]

Sorry, I just copied from Joanthan's post.

Try this:

=Sum({<S_Date = {">='$(=Date(min(S_Date)))' <='$(=Date(today()-1))'"}>} Sales_limit)

But no problem, Now i'ts working.

Why in this case should I use with double quotes?

Tks