null values

[ssriramin19]

Hello All,

I have a expression like

IF([ABC Indicator]='A',IF(COUNT([Batch ID])>=20,1,1-fabs((20-COUNT([Batch ID]))/20)),IF([ABC Indicator]='C',IF(COUNT([Batch ID])<=12,1,1-fabs((12-COUNT([Batch ID]))/12)),

IF([ABC Indicator]='B',IF(COUNT([Batch ID])>24,1-fabs((24-COUNT([Batch ID]))/24),IF(COUNT([Batch ID])<11,1-fabs((11-COUNT([Batch ID]))/11),1)))))

For certain batch id's the values of the expression is null . How to eliminate the null values in the table.

Can any one please suggest me how to eliminate the null symbol

Thanks

Sriram

[ahaahaaha]

Hi,

May be change representation value NULL to zero?

Regards,

Andrey

[ssriramin19]

The above suggestion works but is there option to re write the expression using is null statement. I just looking at other possibilities ..

Kindly advice

Thanks

Sriram

[ahaahaaha]

May be field name change to expression, like this

If(IsNull([YourFieldName])=-1, 0, [YourFieldName])

Andrey

[ssriramin19]

I must not show any corresponding dimension values and related expression values also.

Kindly suggest some approach.

Thanks

Sriram

[ssriramin19]

I will try on this option , thanks for the suggestion

[Peter_Cammaert]

In a straight table, a row will disappear if all expression columns either produce NULL or 0. You can force this by testing the value of expression column Hit% by name. For example, in the next expression, you can use:

=IF (Not IsNull([Hit%]), ExpressionForThisColumn)

which will also result in a NULL value if column Hit% contains NULL.