10 Replies Latest reply on Mar 19, 2014 5:14 PM by carlo.m

    Parse Error

    swheeler

      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

      )