Replace Null, Dash Value with zero through script

[sona_sa]

Hi,

In attached QVW, I want to replace null, '-' Value with 0 (Numeric Zero). By Script level or Expression level, not from layout level (like Suppress Null Value in Dimension and Presentation level - Set - value as 0).

Please have a look and do the needful.

Regards,

QV TEAM

[jwjackso]

Look at the NullDisplay and NullValue  settings.  The best option is to control the nulls in the original datasource.

[sona_sa]

I tried all the way from all script level. But able to get the proper solution. 😞

Regards,

QV TEAM

[sona_sa]

Dear Team,

I tried all the way from all script level. But not able to get the proper solution.  Just I want zero (0), intead of  dash (-), but script level.😞

I tried trim, isnull, len, set variable, by using nullvalue etc.

Regards,

QV TEAM