calculation question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a report where one field the user chooses individual or unit
then a separate field that states number. Is it possible at the bottom of
the report for me to run a calculation that would say sum all the records in
the number field for those who are individuals?
--
 
You can change field names and values below to yours:

=Sum(Abs([TextField] = "Some value") * [Numeric Field])

[TextField] = "Some value" returns either true/-1 or false/0
Abs() converts -1 to 1 and 0 to 0
 
Back
Top