Currency field doesn't show decimals correctly if calculated from integers

[zcapkova (Zuzana Čapková)]

I have a currency field that is calculated as a division of an integer field by an integer constant 100. When shown in the screen (GetRows) the amounts are shown with zeros in the decimals places. When a row is selected (MasterRecord) the decimals are shown correctly.

[jsusen (Jindřich Sušeň)]

It was concluded that this is an edge case. The underlying problem is difficult to fix and it is a result of design decisions by Microsoft (in the DataSet class).

The function call documentation was updated to help anyone who encounters this issue.

1150×1150 16.3 KB

Function Call Field This field type allows you to create a calculated field by calling a function. When using some of the standard functions the calculations will be done in-memory. It means that when calculating e.g. a price total (TotalPrice = Quantity * UnitPrice) this calculation will happen just when the user will change either a Quantity or a UnitPrice. The user will then get an immediate response. When using database functions this is not possible and the data will be re-evaluated afte…

[jsusen (Jindřich Sušeň)]

@tvavrda please confirm that the solution is adequate.