19 Replies Latest reply: Oct 28, 2016 1:16 PM by Noha Salem RSS

    Since Last End Day SLED

    Noha Salem

      Hi Everyone,

       

      I have a file from which I want to get the amount for the SLED or Since Last End Day

       

      But I can't figure out how to get it ?

       

       

      I have tried a bunch of stuff that didn't work like the following

       

      Sum({$<[GLDET.GLD_AMT]=P({1<Date={$(=Day(Max([GLDET.GLD_DATE]))}>}[GLDET.GLD_AMT])>}[GLDET.GLD_AMT])

       

      Sum({<Year=, Month=, Day=,[GLDET.GLD_DATE]={">=$(=Num(LastWorkDate(Max([GLDET.GLD_DATE]))))<=$(=Day(Max([GLDET.GLD_DATE])))"}>} [GLDET.GLD_AMT])

       

       

      so the date comes from [GLDET.GLD_DATE] and the amount comes from [GLDET.GLD_AMT]

       

      I also want the YTD and MTD. I have used the following that did work but I want it to stay as year and as month even if the whole date is selected because currently if in the filter Year is selected then month then day all the 3 columns converts into the same number.

       

      for YTD:

       

      Sum({<Year=, Month=,Day=,[GLDET.GLD_DATE]={">=$(=Num(YearStart(Max([GLDET.GLD_DATE]))))<=$(=Max([GLDET.GLD_DATE]))"}>} [GLDET.GLD_AMT])

       

      for MTD:

       

       

      Sum({<Year=, Month=,Day=, [GLDET.GLD_DATE]={">=$(=Num(MonthStart(Max([GLDET.GLD_DATE]))))<=$(=Max([GLDET.GLD_DATE]))"}>} [GLDET.GLD_AMT])

       

       

      Thanks in advance.

       

      Noha