1 Reply Latest reply on Nov 30, 2016 1:41 PM by Norbert Maijoor

    Need Help with a Conditional Calculated Field

    Alexander Elfering

      Hello,

       

      I am trying to create a chart that shows whether a driver met a specific percent threshold consecutively for three months. So I am trying to create a calculated field that shows drivers that are like A, and filters out drivers like B and C. But I am not sure what the formula should be.

       

      Percent Threshold
      Driver #Vehicle #AugustSeptemberOctober
      AAB######
      BBC####
      CCD####

       

      This is what I have so far, but it doesn't filter out drivers met that threshold consecutively for three months.

       

      IF TOTAL([Percent Threshold]) > .50 THEN 'Show' ELSE 'REMOVE' END

       

      Would someone be able to help me with what I need to do to filter out drivers like B & C?

       

      Thank you!!!

       

      Alex