none
Report section totals by outcome RRS feed

  • Question

  • Hi,

    I would like to count a field in a report based on the content of that field, to go in the section footer (EnforcementType footer). So I have totals for each type of enforcement.

    So the fields are InvestigationOutcome and EnforcmentType

    Here is my current report

    Here is the design view

    Is there a solution like an IF / count?

    I tried something like this =count(Iif([EnforcementType]="A")) but no success.

    Any assistance appreciated.

    Thanks

    John






    JG



    Tuesday, September 18, 2018 9:55 PM

Answers

  • For example:

    =Abs(Sum([EnforcementType]="A"))


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Tuesday, September 18, 2018 10:33 PM

All replies