Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QV-Community .
Today I got a question concerning set analysis (I think it is set analysis).
I got (monthly) Sales-values from january 2017 until july 2018. For a chart I just want to mention sales from October 2017 until the end (july 2018).
I tried following set analysis, but it did not work:
Sum ( { 1< date = {>43009} > } sales-field)
Excel says 43009 is equal to 01.10.2017. Do you know where my wrong command is?
Thank you for your help!
Jakob
Is you date field in number format? If it is, then try this
Sum({1<date = {">43009"}>} sales-field)
works perfectly, thanks Sunny!
Do you also know the script if I want to have sales FROM this date UNTIL a special date, for example '43312'?
this doesnt work unfortunately:
Sum ( {1 < date = {'>43009 AND <43312'} > } sales-field)
maybe you have a hint
Jakob
This
Sum({1<date = {">43009<43312"}>} sales-field)
perfect THANKS A LOT
No problem at all