Calculated fields are integral part of configuration in Siebel and there is no need to explain about them as their name is self explanatory.

While creating a calculated field we seldom give thought about the data type of the calculated field we are creating. The default data type of a calculated field is DTYPE_TEXT.

It won’t matter much if the calculated value of the field is string like Full Name which is concatenation of First Name and Last Name but if the calculated value that is returned is as an Integer for example the expression given below:


IfNull(Count(“Order Entry – Line Items”),0)

It will return the count of the records or 0 if no record is found. If you don’t change data type of the calculated field then it will be DTYPE_TEXT which is the default data type.

Now, if this field is used in another calculated field for performing a mathematical operation e.g. addition (+), then it will result in string concatenation not addition which is not what you want.

Moral of the post

Always make sure that the data type of the calculated field is according the type of the result its calculation will give.

OkAvarageGoodVery GoodExcellent (4 votes, average: 2.75 out of 5)
Loading ... Loading ...