When you use the Sum Aggregate function
, it acquires the Type
of the first number added to the total. For example, if the first number is 0 (which will be accepted as an Integer), all next addends will be converted to Integer. That's why the field with the total Sum will be calculated and represented as an Integer.
Note that the Sum will be calculated first (i.e. as Integer) and then the TextBox where the result is displayed will be formatted with the provided Format
, hence the value will look as if *not* correctly calculated.
The right Expression in your case should be as follows :
The explicit 0.0
assures that the hard-coded value will be taken as a float/double.
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal
and vote to affect the priority of the items