Set Analysis: Only values of a few months (which are in a row=

[jakobjosef]

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

[sunny_talwar]

Is you date field in number format? If it is, then try this

Sum({1<date = {">43009"}>} sales-field)

[jakobjosef]

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

[sunny_talwar]

This

Sum({1<date = {">43009<43312"}>} sales-field)

[jakobjosef]

perfect THANKS A LOT

[sunny_talwar]

No problem at all