+3Hello,
I’m trying to make this calcul to keep only the value on the last month of the quarter:
'EE_Ramping Employees'
[By lastnonzero: '[01] OBROC_DATA HUB'::Month [FILTER: '[01] OBROC_DATA HUB'::Month.Quarter <> '[01] OBROC_DATA HUB':: (Month + 1).Quarter].Quarter]
But I got this error message:
Can you please help me.
Regards,
Rockney
Best answer by Benoit
I think there is a wrong parenthesis in the middle:
I’d try this:
<> ('[01] OBROC_DATA HUB'::Month+1).Quarter].Quarter]
+15Hi Rockney,
it seems you have 3 little dots at the end of your first line?
They’re highlighted by the formula bar, and they could be invisible characters copied over from another source.
Can you try removing them eventually?
+3Hello Benoit,
Thank you for this remark.
I removed the 3 little dots at the end of my first line and I still got the same error message.
Regards,
Rockney
+15I think there is a wrong parenthesis in the middle:
I’d try this:
<> ('[01] OBROC_DATA HUB'::Month+1).Quarter].Quarter]
+3Hello Benoit,
Thank you for your help.
I found the same solution concerning the parenthesis and I’ve adjusted, it’s now working.
Thnak you again.
Regards,
Rockney
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
