Multiple rules in formula

[joep_026]

Hello all,

I have a question regarding multiple rules in 1 formula. This is the line:

sum({$<WEEK= {">=$(CURRENTWEEK)"} ,WEEK= {" <=$(TARGETWEEK)"}, YEAR = {"$(LASTYEAR)"}>}SALES)

Now, as you can see I want the sales of last year from this week untill the target week (which is week 46). So I want the sales between week 32 and 46 of last year. Using this formula now,  I get both the sales of greater than week 32 and smaller than 46, but it adds up both of the values, so the value is too high.

I was wondering if there is a way to fix this, maybe using something as the AND formula.

I'm looking forward to hearing from you!

[tm_burgers · Accepted solution]

Your formula is <= / >=

Which includes the week you are referring to. If you want to exclude the target week just use <

You can also simplify 

sum({$<WEEK= {">=$(Current Week) <$(TARGETWEEK)"}, YEAR = {"$(LASTYEAR)"}>}SALES)

Don't need to refer to week twice. 

[joep_026]

Thank you! It works.