Receiving Error When Prompting Values from Field Created from a Case Statement

Summary

Cannot function ship the following expression: EVALUATE. (HY000)

Content

I have created a Dashboard Analysis and Prompt from the following subject area: Subledger Accounting - Journals Real Time. 

The requirement is to have the ability to filter the Analysis by the individual COA segments like users can do currently in several ERP modules (i.e.Fund, Department, Account, Function Project). The following columns are available: Fund, Department, and Account. The following columns are not: Function, Project.

I created the columns by using a CASE statement and the Concatenated Segments column: 

• Function: (CASE WHEN LENGTH ("GL Account"."Concatenated Segments") = '38'  THEN SUBSTRING ("GL Account"."Concatenated Segments" FROM 12 FOR 5) ELSE NULL END)