Chart requirements

[suvechha_b]

How can I show the field if it doesnot have values .

Please see the below requirement :

the first reporting code/item doesnot have any order value , thus it not showing in the chart.

My requirements is, I need to show the order row with '0' values .

[suvechha_b]

But the particular Item is not having order data , then how can I show '0' ?

Can you help me how to manually insert the rows with zero. ?

Chart requirements

[ahmar811]

I you want to show Zero if data in not available

just put '0' on Null symbol and Missing symbol in Presentation tab

and another option is you can put the condition on Dimension like

if(isnull(order) or order=' ' or order='','0',order)

hope this help you

[suvechha_b]

Order field is not dimension field .

Order is calculative field :

=sum({<[Fin Year]=,[Fiscal Month]=,[Sale Month]={$(vCurrMonth)} >} $(vCalc))

and there are many calculative fields.

[Kushal_Chawda]

= if( isnull(YourExpression),0,YourExpression)

or

alt(YourExpression,0)

Now go to presentation and uncheck suppress zero value

[jagan]

Hi,

Check this link

How to display 0 when there is no record

Regards,

Jagan.

[#7]

You have to uncheck that property as said by other community members.

You can write our expression as sum(0) +  your expression

Thanks

Khushboo