6 Replies Latest reply: Apr 22, 2016 10:58 AM by Gysbert Wassenaar RSS

    Exclude rows based on set analysis value

    Humza Yusuf

      I have a sample list of jobs with a spend value per job based on a previous days snapshot and today's snapshot. I need to exclude all rows of data which have 0 in the variance column

       

      Yesterdays Amount uses the following Set analysis - sum({<rundate ={"$(vPreviousRunDate)"}>} total_amount)

      Today's Amount uses the following Set analysis - sum({<rundate ={"$(vCurrentRunDate)"}>} total_amount)

      Variance uses the following set analysis -  sum({<rundate ={"$(vCurrentRunDate)"}>} total_amount) - sum({<rundate ={"$(vPreviousRunDate)"}>} total_amount)

         

      Booking DateJob NoYesterday's AmountTodays AmountVariance
      01/03/201611141347576656
      02/03/20162631963190
      03/03/2016314887474910138
      04/03/20164752975290
      05/03/201651119637347462
      06/03/20166216621660
      07/03/2016721179201197
      08/03/20168250825080
      09/03/2016968546548306
      10/03/2016101477327114502
      11/03/2016111230495962708
      12/03/201612719271920
      13/03/2016138291460-631
      14/03/201614381038100
      15/03/2016151226856411704
      16/03/2016161214423109834
      17/03/2016176066060
      18/03/201618246424640

       

      Any help would be appreciated.