Set Analysis : using conditions

[#1]

Hi !

I noticed that sometimes

[CODE]
=sum({$<Year=,Month=>} if(Year=$(=Year) and Month=$(=Month), [MyField]))
[/CODE]

doesn't give the same result than

[CODE]
=sum({$} [MyField])
[/CODE]

where "Year" and "Month" are in the selection.

I would like to know how I can use complex conditions in the set analysis statement.

I would like to use a "lower than" and "greater than" and variables and functions.

For instance, I would like to say "only take the values where the date is between a specific date (the selection) and today".

Something like :

[CODE]
=sum({$<Year=,Month=,Day=,Date={">=" & makedate($(=Year), $(=Month), $(=Day)) & "<=" today()}> [MyField])
[/CODE]

Unfortunately, the usage of "&" for the concatenation doesn't seems to work, neither the usage of a function like "makedate" 😞

Even when I set hard values, it doesn't work :

[CODE]
=sum({$<Year=,Month=,Day=,Date={">2008-01-01<2010-01-01"}> [MyField])
[/CODE]

[#2 · Accepted solution]

Hi,

here are an example for a date range.

Good luck!

Rainer

[#3]

The formula in your document is quite the same that the formula I used... but it works

This makes me feel like crazy...

(big thank you )