Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Formatting based on two columns — 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

Formatting based on two columns

Accepted answer
11
Views
1
Comments
edited Mar 28, 2018 2:24PM in Reporting & Analytics for B2C Service 1 comment

Content

Hi,

any advisce how I should go about combining values from two columns?

Basically, I have one column based on a custom field called member value which outputs either Norm (normal customer) and HV (high value customer) like: if((incidents.c$membervaluepriority >= 80),'HV','Norm')

Then I have a column that outputs the group the incident is assigned to (accounts.group_id).

What I would like to achieve is a column that combines these two in the following way: output 1st column, but if the group equals selected groups (3 out of many) change the output from Norm of HV to VIP.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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