Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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. ?
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
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.
= if( isnull(YourExpression),0,YourExpression)
or
alt(YourExpression,0)
Now go to presentation and uncheck suppress zero value
You have to uncheck that property as said by other community members.
You can write our expression as sum(0) + your expression
Thanks
Khushboo