What's new in Customer Journeys?

Connect and learn more!
Receiving Error When Prompting Values from Field Created from a Case Statement — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Question
29
Views
0
Comments

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) 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!