Rounding .5 In Client Expression Returns 0 Instead Of 1 (Doc ID 2219733.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version 12.2.3 and later
Information in this document applies to any platform.

Goal

Rounding .5 in client expression returns 0 instead of 1.

Client Expression:
" if ( isnull( settlement case qty ) ,
  if ( isnull( settlement unit qty ) , round ( settlement lump sum , 2 ) , round ( settlement unit rate * settlement unit qty , 2 ) ) ,
  round ( settlement case rate * settlement case qty , 2 ) ) "

For this example. the data in the worksheet for this series is using the last part of the expression:
round(settlement case rate * settlement case qty , 2 ).

Settlement case rate = $1.0675
Settlement Case Qty = 198
Should be calculating: $211.365 and thus according to the implementation guide should be rounding up not down.
In the worksheet shows 211.3600, but expected 211.3700.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms