0 Replies Latest reply on Aug 26, 2013 3:21 PM by Joe Knight

    % Difference Calculated Fields and Filters

    Joe Knight

      Hello,

       

      I am computing the % difference in rebate for products quarter over quarter.  I want to build a flag where the user can filter for products where a rebate existed in the current quarter but not the previous (vice versa).  The "Flag" column below is what I am trying to build.  The % of change is a table calculation based on Rebate.  I'd like to show both quarters.

       

      Q1Q2
      FLAGRebate% ChangeRebate% Change
      Product AMISSING REBATE$50.00n/a$0.00-100%
      Product Bna/$100.00n/a$90.00-10%
      Product CNEW REBATE$0.00n/a$50.00100%

       

      Apologies, but i can't send an example workbook.  Please let me know if you can help or need additional clarification.


      Thanks,

      Joe K.