error in set modifier

[samuel_brierley]

Can someone explain where im going wrong?

=sum({$< [STSS Month] <= Month(Today())>} [Total Hours])

its supposed to add up total hours for those months that are = to the month of today

[jerem1234]

Try this:

=sum({$<[STSS Month] = {$(=Month(Today()))}>} [Total Hours])

Hope this helps!

[datanibbler]

Hi samuel,

you have to put the second part of your set_expression in brackets if it is an expression,

like this:

>>> = sum({$<[STSS Month} <= {$(=Month(Today()))>} [Total Hours]) <<<

=> Further, that '<=' cannot be used just like that in a set_expression. The "main operator" always has to be an '='. You have to build in that '<=' as part of the expression.

HTH

Best regards,

DataNibbler

[Nicole-Smith]

=sum({$<[STSS Month] = {'<=$(=Month(Today()))'}>} [Total Hours])