Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
bro you have extra closing in set analysis check
try below
sum({$<S_Date={">=$(=Date(min(S_Date)))<=$(=Date(Today()-1))"}>}Sales_limit)
Regards,
Your field must be a date
=sum({$<S_Date={">=$(=Date(min(S_Date)))<=$(=Date(today()-1)))"}>}Sales_limit)
Try this:
=Sum({<S_Date = {">='$(=Date(min(S_Date)))' <='$(=Date(today()-1))'"}>} Sales_limit)
which field? could you give an example please?
tks
tried but no success.
Follow the qvw.
tks
as jonathan suggested try with " (double quote).
It will work.
Regards,
tried but no success.
bro you have extra closing in set analysis check
try below
sum({$<S_Date={">=$(=Date(min(S_Date)))<=$(=Date(Today()-1))"}>}Sales_limit)
Regards,
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