0 Replies Latest reply: Aug 4, 2014 6:08 AM by Jonny Eriksson RSS

    Make an expression for last years period

      Hi!

       

      Since this forum is so helpfull I try agin for som help.

       

      I have two expression that is working  well:

       

       

      Sum({$< PD = {'>=$(startPD) <=$(vCurrentPD)'}>} Belopp )

       

       

      if(GetSelectedCount([År])<>1,
      Sum({<[År]={$(=max([År])-1)} >} Belopp),
      Sum({<[År]={$(=År-1)}>} Belopp))

      I alos have this with a selection in it

       

      if (GetSelectedCount([År])<>1,
      -Sum({<[Rrnummer] = {16}, [År]={$(=max([RäkÅr])-1)} >} Belopp)/1000,
      -Sum({<[Rrnummer] = {16}, [År]={$(=RäkÅr-1)}>} Belopp)/1000)

       

       

       

      The first one gives me the the sum until august (PD=8)

      This works no matter what selection I do in year (=År)

       

      The second gives me the sum for last year but of cours all PD in last year.

       

      That want to do is to combin this so I will show last years belopp until current PD

       

      Any ideas of How to combine these?

       

      Thanks

       

      Jonny