topic Re: Set analysis Previous month in App Development

Set analysis Previous month

mtabernad — Sat, 16 Nov 2024 19:50:05 GMT

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 — Wed, 23 Oct 2019 08:19:47 GMT

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 — Wed, 23 Oct 2019 08:29:37 GMT

Thank you! It works 🙂