Show 0 value in chart.

[narender123]

Hi All,

I have created weekly revenue collection report.

Its working well .When i select a day from day filter then its will show the that day week collection as shown below.But but it is not showing 06/09/2013 date of that week due to 0 amount at 06/09/2013 date.how i can show 0 amount too with 06/09/2013??????????

expression.

=if(GetSelectedCount(Day)=0 ,sum({<Year={$(=max(Year))},Month={$(=MaxString(Month))},Week={$(=Week(Today()-1))},Day=,Month=>}AMOUNT),sum({<Year={$(=max(Year))},Month={$(=MaxString(Month))},Week={$(=vWeek)},Day=,Month=>}AMOUNT))

Please Advice me.

Thanks.

[swuehl]

Please check that option 'suppress zero values' in presentation tab of chart properties is unchecked.

I assume that your date is taken from a calendar table, so there is a record for that date, just the sum(... AMOUNT)  is evaluated to zero?