Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Before the Loading the table use NullAsValue like below
NullAsValue regs; //regs is fieldName of the regs(you mentioned All regs)
Celambarasan
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.
hello you can use
If(IsNull(Field),'Null Value',Field) AS Field.
hope it help
Thanks Rajni but this doesnt solve the non existing relationships thats provoque the null values.
Regards!
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
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.