I am having an issue with the below calculation resulting in an Error Messages simply stating Parse Error. The field I am attempting to get the name of is from an unreleated table.

Has anyone experianced the issue?

Why does the calculation work when I break it down, but not as a whole?

Thanks

Silas

This results in the error.

Let([

n =GetFieldName(zConstants::Capacity_EmployeeHoursPerday);

p =Position ( n;":";0;1);

f =Right(n; Length(n) - (p+1 )) ;

t =Left(n; p-1)];

n &"¶"&

p &"¶"&

f &"¶"&

t

)

By removing the GetFieldName function and just making n equal what the function would have returned the calculation works as expected.

Let([

n ="zConstants::Capacity_EmployeeHoursPerday";

p =Position ( n;":";0;1);

f =Right(n; Length(n) - (p+1 )) ;

t =Left(n; p-1)];

n &"¶"&

p &"¶"&

f &"¶"&

t

)

The below also works

Let(

n =GetFieldName(zConstants::Capacity_EmployeeHoursPerday);

n

)

Is there a relationship between the Charting table and zConstants?

Or is the Capacity_EmployeeHoursPerday field a global field?