9 Replies Latest reply: Jul 26, 2017 8:00 AM by Phil Speight RSS

    Exclude Selections but keep set analysis

    Phil Speight

      Hi I have a chart that calculates and shows the most recent FTE.  The problem I have is that if I change the 'Month' or 'Year' selection the values disappear.  Below is the expression:

       

       

      Sum(

      {<

      Employed_Staff.Headcount_Date = {'$(=Max(Employed_Staff.Headcount_Date))'},

      Employed_Staff.Weekly_Monthly={'Weekly'}>}

        Employed_Staff.FTE)

       

      I tried the following too, but this also loses the data when I select a month or year:

       

      Sum(

      {1< Employed_Staff.Headcount_Date = {'$(=Max(Employed_Staff.Headcount_Date))'},

      Employed_Staff.Weekly_Monthly={'Weekly'}>}

      Employed_Staff.FTE)

       

      I did think that I could detach the chart, but not sure if it will refresh when the new week's data comes into the report?

       

      Is there a better way to do this?

       

       

      Regards

       

       

      Phil