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 laterInformation in this document applies to any platform.
Symptoms
On : 15.16 [IP2015] version, Configuration  General
ACTUAL BEHAVIOR

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
EXPECTED BEHAVIOR

Calculated field should take the decimal value.
STEPS

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
Changes
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.
Cause
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