What's new in Customer Journeys?

Connect and learn more!
Calculated Field in OTBI Prompt — 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

Calculated Field in OTBI Prompt

Accepted answer
38
Views
8
Comments

Summary: Wish to have Calculated field in OTBI prompt. I want to have 3 prompts based on the given table data below:

  1. Assignment Last Update Date
  2. Grade Change Flag
  3. Grade Name

Can anyone guide on how to have Prompts for no. 2 and 3 .

How to use "Grade Code" in Prompts and have the proper result?

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

CASE WHEN MAX("Grade"."Grade Code") = MIN("Grade"."Grade Code") THEN 'N' ELSE 'Y' END "Change of Grade"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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