Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
Thank you! It works 🙂