Less than or equal to in set analysis

[zagzebski]

This should be pretty simple but for some reason not working as expected.

I have an expression that uses the following set:

Month={"<=$(=max(Month))"}

The Month fields is : 201401, 201402, 201403,,,etc.

When I select (for example) 201403 I would expect that my expression would sum on 201401, 201402, and 201403 because the expression should take less than or equal to the max selected value. However it only uses 201403.

Is this because the Month field is a text field? If so how could I rewrite to make this work?

Thanks in advance...

[MK_QSL · Accepted solution]

Month = {'<=$(=Max(Month))'}

or

try

Month = {'<=$(==Date(Max(Month),'YYYYMM'))'}

[zagzebski]

Thanks for the response.

Unfortunately it is still only bringing back the selected month, not the prior months.

[MK_QSL]

Month = {'<=$(=Date(Max(Month),'YYYYMM'))'}

[alexandros17]

Are you sure that values computed is present for previous months?

[zagzebski]

Yes there are.

[alexandros17]

Syntax seems correct, but anyway try this ...

Sum({$ <Month={'<0201404'}>} myField)

that is fix a month and paste in the set analysis as showed