Demantra Solutions - EBS (MOSC)

MOSC Banner

Need help with series Color Expression to include more than two conditions

edited Jul 28, 2014 8:15AM in Demantra Solutions - EBS (MOSC) 2 commentsAnswered ✓

Hello Demantra Experts,

I am trying to create a color expression for a series to include multiple conditions but have not been successful.

Here are the conditions I would like to include for this series:

Series name: 4 Week Lag Absolute Pct Err

Conditions:

1 - If 4 Week Lag Absolute Pct Err is more than 10% and less 100% make these cells red.

2 - If 4 Week Lag Absolute Pct Err is less than 10% (& more than 0%) make these cells green.

3 - Anything Else make them black.

I have got to this so far If(4 Week Lag Absolute Pct Err>0.1 AND 4 Week Lag Absolute Pct Err<1,255)

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

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center