Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need some suggestions on set analysis expression
i have a chart that should be changed
May be this:
=Sum({$<Period = {">0<=13"}>}BS_Budget)
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)