Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
if(len([Field name])>0,Nul(),[Field name]) should work.
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