AnsweredAssumed Answered

How to create a total amount calculation in a report based on field entries

Question asked by mel617 on Aug 10, 2016
Latest reply on Aug 10, 2016 by alangodfrey

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.