Null bar in waterfall bar chart

[Anonymous]

Hi

I have an issue in the graphics of a waterfall chart. For some bars, I have null value or zero. Thus there is an empty space for the missing bar. I would like to still display at least the labelling for the bar. Is this possible when using dual?  Please find below image

Thanks

Hasnaa

[avinashelite]

OK , if you doesn't have dimension then please check the expression calculation once , I feel you don't have zero values, those are null values that's why they are not appearing, write a expression to check whether value is  null , id so then set it to zero than only you will be able to see that value in the graph

[Anonymous]

ya its a null value, i tried using the following it still does not show anything for the missing bar

=if(NumSum($(f_Unit_Cost_In_Euro_StockInj))=0,

'Stock' & chr(10) & 'Injection',

dual('Stock' & chr(10) & 'Injection' & chr(10) & num($(f_Unit_Cost_In_Euro_StockInj),'# ##0,00'),$(f_Unit_Cost_In_Euro_StockInj)))

[avinashelite]

can you share your app, so that it will be helpful to write the expression according to the data

[Anonymous]

Hi. Sorry I cant share it as its a corporate stuffs. Thanks for your help

Regards

Hasnaa