Count units between weeks

[Anonymous]

Hi all,

I'm struggling.

What I'm trying to do is count how many units were sold between two weeks ago and 24 weeks ago.

My expression is below,

sum({<UNIT.SOLD_WEEK=    {"<=$(=$(Week(today())-2)>=$(=$(Week(today())-24)"} UNIT.TOTALSOLD)

Could anyone point out where I'm going wrong?

Thanks

Gareth

[Kushal_Chawda · Accepted solution]

try,

sum({<UNIT.SOLD_WEEK=    {"<=$(=Week(today())-2)>=$(=Week(today())-24)"} >}UNIT.TOTALSOLD)

[sunny_talwar]

Can also try this:

Sum({<UNIT.SOLD_WEEK=    {"$(='<=' & (Week(Today())-2) & '>=' & (Week(Today())-24))"}>} UNIT.TOTALSOLD)

[#4]

Hi,

you missed out the set modifier and thats why the error.

Try like this:

sum({<UNIT.SOLD_WEEK= {">=$(=Week(today())-24)<=$(=Week(today())-2)"} >}UNIT.TOTALSOLD)

[sgrice]

This will not work over year end.

You will need a Absolute week number to do this.

[Anonymous]

Thanks everyone you've all been a great help!