Skip to main content

Hello,

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 tFILTER: ':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

Hi 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?

 

 

Hello 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

I think there is a wrong parenthesis in the middle:

I’d try this:

<> ('(01] OBROC_DATA HUB'::Month+1).Quarter].Quarter]

Hello 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 

Reply


Ask your question here!

Terms & ConditionsCookie settings