Set analysis

[#1]

I am trying to calculate the set based on the month and sum the accounts.

Sum{<Month = {"=>$(Month(today()))<=$(MaxString(Month)) "}>} accounts .The value should be pretty much from the present month and to end of the year.

But the set analysis is not working properly. Please advise.

[maxgro]

sum({$<Month ={">=$(=max(Month(Today())))<=$(=max(Month))"}>} account)

or

sum({$<Month ={">=$(=max(Month(Today())))<=12"}>} account)

[Vegar]

Set with month() can be tricky. Month is a dual value and can be string and number. Make sure that you don't compare a digit with a string.

-Vegar