Help - suppress nulls

[joris_lansdaal]

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

[sunny_talwar · Accepted solution]

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

[joris_lansdaal]

Bingo!

[joris_lansdaal]

Thanks man!

[sunny_talwar]

Adding back other expressions and properties doesn't break the chart? I hope not