I have a calculated field of type Decimal where I may dynamically return 0 in some of the rows of data.

If this happens with the first data row, it will not respect the selected data type and will instead infer that the type of data is an integer.

If I use this calculated field in an aggregate function such as Sum(), since the type of the first value will be integer, it will treat the other values as integers as well and the total sum will be incorrectly aggregated.