Calculated Dimension question

[#1]

Hi,

I'm working with version 11.

as a calculated dimension I use the following:

= if( Week_End_Flag = 1, BacklogYearWeek)

So year/week is displayed on the X-axis.

What happens is that the sum of values with no defined week is displayed as well.

See attached picture.

Any ideas how to prevent this  value?

Thanks!

[sujeetsingh]

You can write the expression to label this null value with "No WEEK".

[Gysbert_Wassenaar · Accepted solution]

Enable the Suppress When Value Is Null option for your calculated dimension.

[er_mohit]

either you can check on suppress null value in dimension tab for that particular dimension and in dimension limit tab check on show total

hope it  helps