How to write the expression

[suvechha_b]

Hi All,

How can implement 0 to the value in expression when the value is NULL.

See the screenshot.

In the chart ,

I have three category - Forecast Invoice Order.

But when there is no value for Forecast or Order , its not refelecting in the chart.

My Requirement, I need to show the Forecast Or Order Value which are not present by 0.

Sample Model attached.

[Peter_Cammaert]

You can try with "Show all values" on Dimension Amount Type, and disabling "Suppress zero values" in Presentation.

Note that your chart may also show Null values (can be suppressed by disabling Null values in the first Dimension) and may not show values that aren't even present in your data model. Creating dummy zero records may solve that one.

Best,

Peter

[suvechha_b]

Hi Peter,

I have tried disabling "Suppress zero values" but . If the values  aren't even present in your data model.

Creating dummy zero records may solve that one. - How to create dummy zero records ?

Please can you show by exapmle.

I have attached the sample model.

Thanks,

[#4]

Try flagging the fields in the script using something like this:

if(IsNull([Field1]), [Field1] = 0, [Field1]) as [Field1]