I am trying to create a calculation on revenue report that totals the $ amount that is entered in the "Contract New Price" field in all records in the database if the file Final_Sale_Rental = "Final Sale"
I have created the below equation but seems to be pulling the value of the current record only but I need it to pull all the records that fit this criteria.
If (Final_Sale_Rental = "New Final Sale Contract"; Sum (Contract New Price))
I hope this makes sense. Any help would be appreciated.