Calculated Field Not Considering Decimal Values During Calculations Of Total Amount

(Doc ID 2338200.1)

Last updated on APRIL 30, 2018

Applies to:

Siebel CRM - Version 15.16 [IP2015] and later
Information 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