Demantra Solutions - EBS (MOSC)

MOSC Banner

Server Expression cannot be negative

edited Nov 12, 2014 10:08AM in Demantra Solutions - EBS (MOSC) 1 commentAnswered

Folks,

How do we write the server expression to always display 0 or positive value? The value cannot be negative.

Here is my Server Expression.

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

round(sum( nvl(   branch_data.cie_vmi_ss_cust_qty,0))) + round(sum( nvl(   branch_data.cie_vd_dm_adj_qty,0))) - round(sum( nvl(   branch_data.cie_oh_qty,0))) -  round(sum( nvl(   branch_data.cie_disc_job,0)))

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

Thanks for your advice.

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