3 Replies Latest reply on Sep 23, 2016 2:48 AM by Kashish Chauhan

    Assistance required with creating “Percentage of Calculated Fields”

    Lance Martens

      Hi All,

       

      I would appreciate any assistance with how to go about configuring my worksheet to determine two types of “Percentage of Calculated Fields”?

       

      Logic:

      • I have 12 months’ worth of actual flux percentage data at a sample rate of 1min
      • I have created a filter to represent the Avg. % between 1.13 and 3.66

       

      Required:

      • I would like calculated fields that will enable me to determine the following % queries, namely:
      • The % out of all the 12 months data the Actual % was > 1.13
      • The % out of all the 12 months data the Actual % was < 0.8

       

      My workbook is attached.

       

      Any assistance will be appreciated,

       

      Cheers,

      Lance