topic How to Remove null values from measures? in App Development

How to Remove null values from measures?

Sat, 12 Mar 2016 06:43:54 GMT

To remove Null from dimension, we uncheck the Show Null check-box. Now my question is when i create a measure the show null value option is not available so how can i remove null values from the measure that i created? or if u can provide me with an alternate method to remove null values from measures.

Thank you in advance.

Re: How to Remove null values from measures?

swuehl — Sat, 12 Mar 2016 09:57:08 GMT

Open the chart properties, then go to

Add-Ons -> Data processing (or similar, 'Data handling'? I am not using the english version) -> Disable 'Show NULL values'

Re: How to Remove null values from measures?

undergrinder — Sat, 12 Mar 2016 10:24:39 GMT

Hi Brazil,

Try the following formula like method, if you think a null value as 0:

=if(your expression=0,'',your expression)

Then you should disable show null values.

If you already have Null as measure, just uncheck the sow nulls chechkbox.

Re: How to Remove null values from measures?

Mon, 14 Mar 2016 07:36:22 GMT

you could add the measure into an IF statement in your dimension:

IF(<measure>=NULL(),NULL(),<dimension>)

then when you hide nulls on this dimension, it will hide your null measures.