Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm a bit stuck. Let me introduce my challenge with below graph.
I don't want May-2016 in my analysis because I only want closed months and not the running month.This means i want a Null in May which are suppresed
M36Flag is used flag the last 36 closed months
Two expressions are used:
Volume=If(M36Flag=0,Null(),sum($(VarFact))/1000*$(VarFactor))
Trend= If(M36Flag=0,Null(),below( sum({<M36Flag={1}>} $(VarFact)),0,12) /1000*VarFactor)
The first works fine, but I dont understand why Trend is not Null in May2016.
Any suggestions?
thanks Joris
That is just so strange... Would you be able to post a sample? Or may be try recreating the chart from scratch and try with the trend expression first
Bingo!
Thanks man!
Adding back other expressions and properties doesn't break the chart? I hope not