8 Replies Latest reply: May 10, 2016 10:08 AM by Marcus Sommer RSS

    Need help code, expressions.

    Marius August Larsen

      Hi!

       

      Can someone help me combine these two expressions:

       

      1:

       

      if(vChange=1,

          num(sum(pick(match(Målepkt_Gruppering, 22), kWhVG)) - sum(kWh),'##0'), //numbers

          num((sum(pick(match(Målepkt_Gruppering, 22), kWhVG)) - sum(kWh))/sum(kWhVG) ,'##,#%') //percentage

      )

       

      2:

      Sum({<Uke= {$(= max(Uke-1))}>}kWh)

      Sum({<Uke= {$(= max(Uke-1))}>}kWhVG)

       

       

      info;

      I have a pivot table that displays the difference between two values ( Diff HM-UM) and i want the right collum/row to show the same as Diff HM-UM but only the last week.

       

      You know if i select week 6, i want the collum on the right to show me values for week 5.