Calculated Field Not Considering Decimal Values During Calculations Of Total Amount
Last updated on DECEMBER 11, 2017
Applies to:Siebel CRM - Version 15.16 [IP2015] and later
Information in this document applies to any platform.
On : 15.16 [IP2015] version, Configuration - General
Calculated field not considering decimal values during calculations of total amount.
We have fields ENTP Req Amount Per Unit which is db field of DTYPE_NUMBER, Quantity of Type DTYPE_INTEGER, and Total Req Amount calculated field.
Now for Total Req Amount calculated expression is [ENTP Req Amount Per Unit] * [Quantity] but problem is during calculation if [ENTP Req Amount Per Unit] field has value for example as 25.67 then its considering only 25 and multiplying with quantity which is resulting in incorrect Total Amount.
For Calculated field i have already tried with type as DTYPE_CURRENCY, DTYPE_NUMBER and DTYPE_TEXT for nothing is working.
Please let us know what needs to be done for calculated field to consider decimal values for calculations
Calculated field should take the decimal value.
The issue can be reproduced at will with the following steps:
1. Create a Calculated field "Total Req Amount " with DTYPE_NUMBER or DTYPE_CURRENCY with expression as [ENTP Req Amount Per Unit] * [Quantity] and check the decimals
When calculated fields of Type DTYPE_CURRENCY are added to DTYPE_INTEGER then the result which is of DTYPE_CURRENCY is not showing the Decimal values.
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