How to create a condition using a variable?

[Anonymous]

Hi,

I have a field named week with 104 weeks.

I want to filter a sum for the weeks going between a variable named "vPeriod" and week 52. I have been trying things like the following unsuccessfully.

Sum ( { <Week = {"<=52"}, Week={">$(vPeriod)"}>}  Sales)

Any help?Thanks

[johanlindell]

Hi!

You were close. Did a formula similar to this a week ago. It should be:

Sum({ <Week = {'<=52>$(vPeriod)'}>}  Sales)

Best Regars

Johan Lindell

[#3]

Hi,

Put the value 52 in variable ,let the name of variable be "vVal"

thn try the below expression

=sum({<Week ={">$(vPeriod) <=$(vVal)"}>} Sales)

hope this will work.