Set analysis Previous month

[mtabernad]

Hi everyone,

I'm just trying to build an expression through set analysis for previous month:

=count({$<Month={num(month(addmonths(max(date_id),-1)),'00')}>}connect_time)

but I get this error (also shown on attached Image):

Error in set modifier ad hoc element list: ',' or ')' expected

It seems like a "," or ")" is missing but however much I check it I think expression is OK.

Could anyone help me please?

Thank you in advance!

[DavidM · Accepted solution]

When using formula in set expression you need to use format below (in red):

=count({$<Month={"$(=num(month(addmonths(max(date_id),-1)),'00')"}>}connect_time)

This should work if the formula num(month(addmonths(max(date_id),-1)),'00') is ok

[mtabernad]

Thank you! It works  🙂