NULL Values in Object

[venkatbidevelop]

Hi  All,

Greetings!

I have  10 columns out of that 3 will be the dimension. (Created as straight chart)

I have used expressions in all the remaining 7 columns/fields and enabled the option suppress null/zero values in presentation tab. But still getting Null value in my object(Result). It is so weird.

Kindly let me know your suggestions.

Thanks in advance.

Regards,
Venkat

[Gysbert_Wassenaar]

Check that the Suppress When Value is Null option is enabled for all dimensions.

[santhiqlik]

Have you checked "Suppress when value is Null" in Dimensions tab in chart?

[venkatbidevelop]

Hi Gysbert,

Thanks for your response.

Yeah, I enabled that option already i think some condition inside dimension/expression is blocking it to work properly.

Now I am trying to fix the conditions.

Regards,
Venkat

[sasis551]

Hi 

Add calculated Dimensiom==>if (len(column name)>0,column name)

can u try it once?

[venkatbidevelop]

Thanks all for the suggestions.

I have fixed the issue as mentioned some problem with set expression field.