Suppress Blank Fields

[evansabres]

Hello -

I have a field, age, for which each record either has a range 'Age 18-19' or is blank. How can I, in a chart, display only the fields that have a value in this field.

Thank you.

[its_anandrjs]

Hi,

You can try with

=If(len(DimensionName) > 0 DimensionName)

And click on the suppress when value is null option in the chart properties

Regards

Anand

[Anonymous]

if(len([Field name])>0,Nul(),[Field name]) should work.

[its_anandrjs · Accepted solution]

Hi,

If you have requires only to load rows which is not null then use this

=If(len(DimensionName) > 0, DimensionName)

Or if both then

=If(len(DimensionName) > 0, DimensionName, NULL( ) )

Regards

Anand