I am running a report with two specific columns that I need to calculate.
The first column is called District and it will have a value of either 1 or 3.
The second column will be AmountPaid and it is set for currency.
I am trying to get my report to calculate out the sums for each district.
if District = 1 then sum(amountpaid)
if District = 3 then sum(amountpaid)