Null as Zero

[manthana_c]

Hello all:

is there anyway to display value NULL key figures as ZERO in any query properties.

Thanks in advance.

[Anand71 · Accepted solution]

Hello,

Please go through the following link.

Thanks.

With regards,

Anand Kumar

[former_member189638]

Just create a Formula Key Figure as below.

FKF = KF + 0.

Hide your KF and use FKF in your query.

[Former Member]

Hi

you can use this put your key figure in place of KF,

( ( 'KF' == 0 ) * 1 + 0)

Hope this could helps.

[]

Regards

satish