0
edits
Changes
Created page with 'The following are examples of calculations that can be entered into the '''Calculated Field''' of the Report Builder. ===Sums=== Add the values in column 10 and 11: [10]+[…'
The following are examples of calculations that can be entered into the '''Calculated Field''' of the [[Report Builder]].
===Sums===
Add the values in column 10 and 11:
[10]+[11]
* If the value in either column 10 or 11 is blank(null), using the above statement will result in incorrect calculations.
Sum column 10 and 11, using zero as the value if the either field is blank:
ifnull([10],0)+ifnull([11],0)
[[Category:Reports]]
===Sums===
Add the values in column 10 and 11:
[10]+[11]
* If the value in either column 10 or 11 is blank(null), using the above statement will result in incorrect calculations.
Sum column 10 and 11, using zero as the value if the either field is blank:
ifnull([10],0)+ifnull([11],0)
[[Category:Reports]]
