43 Replies Latest reply: Feb 16, 2018 4:45 AM by Thiago Justen Teixeira RSS

    Dynamic time expression-selection

    beck bakytbek

      Hi Folks,

       

      i goit a following situation, my table does look like:

       

      ProjectTimeOnTypBudget
      A01.01.2018AA100
      B31.12.2017BB150
      C31.11.2017CC30
      D31.09.2017CC60

       

      and i use as timefilter, that i created on base of master calender the following filter:

       

       

      Timefilter
      2017 11
      2017 10
      2017 09

      2017 08

       

      and i use the following set expression to calculate the budget for every typ of project:

       

        

      Budget:
      Sum({<Typ = {'AA'}>}Budget)100
      Sum({<Typ = {'BB'}>}Budget)150
      Sum({<Typ = {'CC'}>}Budget)90

       

      everything does work great, now i have a question: lets imagine, my reportdate is:

      2017 11 and if i select the date in Timefilter: 2017 11 , then should appear only two project:

       

        

      ProjectTimeOnTypBudget
      A01.01.2018AA100
      B31.12.2017BB

      150

       

      because my timefilter-date: 2017 11 is lower then 01.01.2018 and 31.12.2017

       

      and if select as reporting date 2017 10 then shoudl appear the following projects:

       

        

      ProjectTimeOnTypBudget
      A01.01.2018AA100
      B31.12.2017BB150
      C31.11.2017CC30

       

       

      because my timefilter-date: 2017 10 is lower then 01.01.2018, 31.12.2017 and 31.11.2017

       

      Does have anybody any idea how to handle dynamic this issue with the helps of set expression?

       

      Thanks a lot

       

      Beck