Unexpected token: '*', expected one of: 'as', 'AutoGenerate', 'From', 'From_Field', 'Inline', 'Resident', 'Extension', ...

yamit — Fri, 15 Nov 2024 22:47:06 GMT

Hey,

Can anyone please help me to understand this message?

I have that script-code:

if(IsNull(Step_Time_Closed),
Interval(

(RangeMin(frac($(vToday)), MakeTime(17))

- RangeMax(frac(Step_Actual_Time), MakeTime(7,30)))

+( NetWorkDays(Step_Actual_Time+ 1, $(vToday)) * MakeTime(9,30) )
)) As Time_StepToToday,

The error:

The following error occurred:

Unexpected token: '*', expected one of: 'as', 'AutoGenerate', 'From', 'From_Field', 'Inline', 'Resident', 'Extension', ...

The error occurred here:

LOAD *, Interval( (RangeMin(frac(Step_Time_Closed), MakeTime(17,00)) - RangeMax(frac(Step_Actual_Time), MakeTime(7,30))) + (NetWorkDays(Step_Actual_Time + 1, Step_Time_Closed) * MakeTime(9,30)) ) as Step_Handling_Time, if(IsNull(Step_Time_Closed), Interval( (RangeMin(frac(), MakeTime(17)) - RangeMax(frac(Step_Actual_Time), MakeTime(7,30))) +( NetWorkDays(Step_Actual_Time+ 1, ) >>>>>>*<<<<<< MakeTime(9,30) ) )) As Time_StepToToday,

Your answer is really appreciated!

Re: Unexpected token: '*', expected one of: 'as', 'AutoGenerate', 'From', 'From_Field', 'Inline', 'Resident', 'Extension', ...

jbhappysocks — Wed, 23 Jun 2021 08:31:43 GMT

Hi. I would start with checking your variable vToday, it looks empty.

Then use single quotations around $(vToday) -> '$(vToday)'

topic Re: Unexpected token: '*', expected one of: 'as', 'AutoGenerate', 'From', 'From_Field', 'Inline', 'Resident', 'Extension', ... in Visualization and Usability

Unexpected token: '*', expected one of: 'as', 'AutoGenerate', 'From', 'From_Field', 'Inline', 'Resident', 'Extension', ...

Re: Unexpected token: '*', expected one of: 'as', 'AutoGenerate', 'From', 'From_Field', 'Inline', 'Resident', 'Extension', ...