How to make Null Values Selectables

[#1]

Hi All!!

My question its Simple.

When some report have some null values inside because, for instance, lets suppose that we have 2 tables and not all values from table A have one corresponding value on table B.

If a make an analysis with a Table B value, a null value will appear.

So, theres any way to make this null value selectable? The idea its to select all regs like:

With A Value   300  regs

With B Value   100  regs

With - Value      50 Regs

If you click on A, you can see the 300 datas. but you cannot click on "-" value.

Theres any way to make those 50 regs selectables??

Thanks for All!

Germán.

[CELAMBARASAN]

Hi,

     Before the Loading the table use NullAsValue like below

     NullAsValue regs; //regs is fieldName of the regs(you mentioned All regs)

Celambarasan

[#3]

Thanks for the answer but i think its not correct because the nulls values are due to luck of datas into table B.

So, if i want to make an analysis of an table B dimention, all of the A table values that are not present on B table will appear in NULL into the report.

Thanks anyway.

[rajni_batra]

hello you can use

If(IsNull(Field),'Null Value',Field) AS Field.

hope it help

[#5]

Thanks Rajni but this doesnt solve the non existing relationships thats provoque the null values.

Regards!

[#6]

Try using If(IsNull(Field),'Null Value',Field) in the actual development like in a list box. It won't work in the script unless the table is joined and then you put it in a resident load of the combined tables

[#7]

Hello,

I made NULLs selectable in a chart Dimension by using the formula =if(IsNull(Field),'Nothing') and then selecting 'Suppress When Value Is Null'. This made the Nulls not Null and everything else NULL.