1 Reply Latest reply: Oct 19, 2018 9:24 AM by youssef belloum RSS

    This year and last year

    Jon Erik Lindberg

      I have this expression:

       

      if(Week(today())<19,

      Sum({<År0101={'$(=year(today()-1))'},Framskrivningsalternativ={"Faktisk"}>}Folkemengde_fram_SSB),

      Sum({<År0101={'$(=year(today()))'},Framskrivningsalternativ={"Faktisk"}>}Folkemengde_fram_SSB))

       

      The first conditional expression is supposed to retrieve the sum for last  year. The second expression is supposed to retrieve the sum from the current year.

       

      The first expression does not work correctly. Consequently, both expressions give me the same result (from the current year).