Demantra Solutions - EBS (MOSC)

MOSC Banner

How to convert negative value as zero

edited Sep 27, 2014 5:01AM in Demantra Solutions - EBS (MOSC) 3 commentsAnswered

Hi Gurus,

We have one series 1) Actual CY YTD which has one server expression and one client expression.

Lets say for Actual CY YTD = sum(A) - sum(B), if A=0, B= -10, result give me as -10, where i need 0.

=========================================================================

I thought of writing client expression like if(actual_cy_ytd < 0) then 0

but i already have one client expression for this series. How can I handle this situation.

(Detail Document is enclosed)

Any help would be appreciated.

Thanks,

Venkatesh

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