Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=sum({$<[STSS Month] = {$(=Month(Today()))}>} [Total Hours])
Hope this helps!
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
=sum({$<[STSS Month] = {'<=$(=Month(Today()))'}>} [Total Hours])