simple set

[#1]

Hi

I need some suggestions on set analysis expression

i have a chart that should be changed

[sunny_talwar · Accepted solution]

May be this:

=Sum({$<Period = {">0<=13"}>}BS_Budget)

[rubenmarin]

Hi, I'm not sure of what you want, maybe with this expression?:

=if(MAx(TOTAL [Period]) <= 13 and Min(TOTAL [Period])<> 00,Sum({$<Period=>}BS_Budget),0)

If the values selected contains '0' or '13' it will show '0', in any other case it makes Sum({$<Period=>}BS_Budget)