My Oracle Support Banner

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.


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.