Rounding .5 In Client Expression Returns 0 Instead Of 1
Last updated on DECEMBER 18, 2017
Applies to:Oracle Demantra Predictive Trade Planning - Version 12.2.3 and later
Information in this document applies to any platform.
Rounding .5 in client expression returns 0 instead of 1.
" 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.
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