NULL values

[#1]

Hi

I have expressions which are resulting some data to return a - i.e. a null.  In addition i have dimensions in the same chart objects that may have a -.  I have used the presentation tab on chart properties to set the null symbol to Unknown on the dimension column for example.  However it seems that this applies to all columns in the chart not just the one i which to select against.  Is this correct behavior?  If so how can i get around both of these issues?

Thanks

[its_anandrjs]

Another way you can use Isnull() function for any specific dimension like

If( Isnull(YourNullfield) = -1,'Unknown',YourNullfield)

[#3]

so lets say I have the following:

DerivedX/RowCounter and I have named my expression as Profit then how would your example apply?

Also how would you example apply to a dimension field.  Would this be done in the script or within the chart objects propoerty

[its_anandrjs]

In Expression and in script level both you are able to do with this

If( Isnull(YourNullfield) = -1,'Unknown',YourNullfield)

[PradeepReddy]

Hi,

In Script,

NullAsValue Field1,Field2..;

Set NullValue='@';   // Any symbol

Load the script.

Use the symbol(@) in expression instead of Null value.

Hope this helps you.

Thanks

Pradeep

[#6]

okay thats worked on the dimension in the expression area.

How about in the this example:

Ave Stay I have values which are showing as -.  I want these to be replaced with 0.  This is a calculated expression DerivedX/Row

[its_anandrjs]

Ok i suggest in the load script you replace or change the symbol '-' to 0 then use it in the Expressions or dimension.

[PradeepReddy]

As I understand the requirement, you need to replace the Null value in Dimension with Zero.

This may helps partially.. it won't show the Nullable dimension.

Select the option "Suppress When Value IS Null" from dimensions tab.

[#9]

the only thing is the expression is in the chart object not in the script. 

[PradeepReddy]

Select the option "Suppress When Value IS Null" from dimensions tab from object properties...

Chart Properties---> Dimensions --> Choose the dimension -- > "Suppress When Value Is Null" (select this option)