set analysis - count when value is a given month

[Rkota]

HI there - would greatly appreciate any help with the error in the following expression

=Count({<MoveMonth ={">=$(=Date((AddMonths(Today(),-3)),'MMMMM')"}>} unittranid)

essentially, I'm trying to count by month I.E count(unittranid) when MoveMonth=August - as it is today

"Error in set modifier ad hoc element list; ',' or ')' expected.

Thanks

[its_anandrjs]

Do you have pure month data let me know this.

[Rkota]

thanks for the note -

not sure I understand the question - if you are saying Do I actually have data for the month of august in a "detail table" - then yes.

I think its a syntax issue where i'm missing a , or a ) or something to that effect

[its_anandrjs]

How you compare String field on MoveMonth on SET expression do you have any numeric fields. Let me know about this.

[antoniotiman · Accepted solution]

=Count({<MoveMonth ={">=$(=Date(AddMonths(Today(),-3),'MMMMM'))"}>} unittranid)

[its_anandrjs]

The syntax is missing with on closing bracket and rest is Ok just try only single month in SET expression and let me know.

Ex:-

=Count({<MoveMonth ={"$(=Date((AddMonths(Today(),-3)),'MMMMM'))"} >} unittranid)

[YoussefBelloum]

Hi,

Date((AddMonths(Today(),-3)),'MMMMM' give you: AUGUST

what do you have on the MoveMonth if you put it on a listbox ?

[Rkota]

thanks Antonio.  The right parenthesis was missing.  Appreciate the help.

[Rkota]

thanks for the note Youssef.   I was able to fix it from another reply.

[Rkota]

Thanks Anand.  Worked.  Appreciate the help.