CRM On Demand - Administration (MOSC)

MOSC Banner

Convert a String (via Left function) into a Number

edited Feb 11, 2015 1:00PM in CRM On Demand - Administration (MOSC) 3 comments

Hello again,

I have 9 picklists in a Custom Object 1, all with the same values  (1–Unsatisfactory, 2–Needs Improvement, 3–Achieves Expectations, 4–Exceeds Expectations, 5–Outstanding).  My customer has a requirement to calculate the average value for the 9 fields and display the result on the Detail screen.

I tried calculating in a report and exposing it in the detail screen, but that is no longer supported.

I created a custom Number field to capture the Average.  I created a Workflow (When modified record saved) to pull the first character from the Picklist and update the Average field.    No matter what I do I cannot get the value in the picklist to update the Average field. I know that Workflow Rule condition is being met since other Actions are being executed.  Here is the expression in my workflow:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center