Demantra Solutions - EBS (MOSC)

MOSC Banner

Client Expression causes Worksheet to display no data

edited Jun 11, 2014 2:32PM in Demantra Solutions - EBS (MOSC) 5 commentsAnswered

Hi All,

We have a Worksheet which displays data most of the time but  does not show data for one sceanrio.

We have narrowed down the columns to a specific series which has client expression

*******************

if(isnull(  user adj fcst qty),0,   ( user adj fcst qty +  System Adj Fcst Qty )   * unit_cost )

********************

Please advice how to make this more robust to support null columns--scenario where

1) user adj fcst qty   is null

2) System Adj Fcst Qty  is null

3) Unit_cost is null

Can you please provide me robust expression to incorporate all possibility of Null Scenarios.

Thanks for your help

rgds

Aqil

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