Unifier (MOSC)

MOSC Banner

How can a Integer Amount field be made to read '0' for any negative values

edited Jan 12, 2017 11:59PM in Unifier (MOSC) 10 commentsAnswered ✓

Scenario : A(Currency Amount) * B(Integer Amount) = C(Currency Amount)  [e.g. Rate * Days = Amt]

where B(Integer Amount) is a formula = (Date Field) - (Today Date/Time) [Difference between two date pickers]

We donot want, C to show negative values.We have restrcited A from not holding negative values.B however is a difference b/w two dates which can be a turn negative.What we are trying to, is to set this to '0' if the difference turns negative

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center