This year and last year

[jelindbe]

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).

[YoussefBelloum · Accepted solution]

Hi,

try this:

if(Week(today())<19,

Sum({<År0101={'$(=Year(AddYears(Today(),-1)))'},Framskrivningsalternativ={"Faktisk"}>}Folkemengde_fram_SSB),

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