1 Reply Latest reply on Jun 2, 2016 9:51 AM by Joe Oppelt

    How to create a calculated field with a filter applied within the calculation.

    Andrew Radil

      I have created a 2 calculated fields. One calculates surveys scores by each contractor.







      (count([Q3Result])+count([Q4Result])+count([Q5Result])+count([Q6Result]) +count([Q7Result]))


      The other is a calculated field to filter so I only see results for orders that have been surveyed by contractor.







      This all works good. The problem: I want to put these results in a column on the on the same sheet as the total orders by contractor.. When I add the surveyed filter it affects the total orders surveyed. Is there a way to combine this filter calc with the survey calculation? Right now I have a separate sheet but the customer wants it all on one sheet and abel to be sorted together.