Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this
=Sum({<DYEARWEEK = {"=(DYEARWEEK >= Only({[Start]} YEARWEEK)) and (DYEARWEEK <= Only({[End]} YEARWEEK))"}>}Demand)
Perfect, thank you so much
Hahahaha I see you fixed the helpful response thing.... I am glad it worked