sum between values

[#1]

Hi

Can anyone see what i'd doing wrong here? I am trying to sum the value where the DYEARWEEK (201713 format) is between the StartYrWk and EndYrWk (current selection has the StartYrWk at 201713 and the EndYrWk at 201714.

=sum({<DYEARWEEK = {">=$(StartYrWk)<=$(EndYrWk)"}>}Value)

in other expressions I use p but this doesn't seem to work where you have set analysis following =p

Currently the result of the above is the total sum of the value disregarding the selected ranges.

Any suggestions would be appreciated.

[sunny_talwar]

May be this

=Sum({<DYEARWEEK = {"=(DYEARWEEK >= Only({[Start]} YEARWEEK)) and (DYEARWEEK <= Only({[End]} YEARWEEK))"}>}Demand)

[#3]

Perfect, thank you so much

[sunny_talwar]

Hahahaha I see you fixed the helpful response thing.... I am glad it worked