Hello Victor,
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.
Regards,
Neli
Progress Telerik
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