2 Replies Latest reply: Oct 2, 2015 3:37 PM by Channing Dionisopoulos RSS

    Drilling down

    Channing Dionisopoulos

      Hi all,

       

      Scrap Chart.png

       

      I created the above Scrap Trend per Std Hrs by using the following equation:

       

      (sum({$<YEAR_NO={$(vCurrentYear)} >} UNIT_COST*SCRAP_QTY))

      /

      (sum ({$<YEAR_NO={$(vCurrentYear)} >} TOTAL_HOURS))

       

      and I have a variable called vPriorYear for 2014 and did the same for that.  UNIT_COST AND SCRAP_QTY come from the SCRAP table and TOTAL_HOURS comes from the STDHRS table as shown below.

       

      tables.png

       

       

      When I try to filter the data by Area, Facility, or department, the chart shows 'No data to display', as shown below.  Does anyone know how to fix this?

       

       

      no data.png