null values

[#1]

hi experts,

i have the following set analysis expression for calculating a field in a pivot table.

Expression:

=Num(Avg(Aggr(

Count({<CalendarDate=, CalendarMonthYear= {">=$(=date(MonthStart(Max(CalendarDate))))<=$(=date(Max(CalendarDate)))"}>} Unanswered)

/

(Sum({<CalendarDate=, CalendarMonthYear= {">=$(=date(MonthStart(Max(CalendarDate))))<=$(=date(Max(CalendarDate)))"}>} Answered)

+

Sum({<CalendarDate=, CalendarMonthYear= {">=$(=date(MonthStart(Max(CalendarDate))))<=$(=date(Max(CalendarDate)))"}>} Unanswered))

,branchname)))

i m getting some null values in some rows. because of this null value, the next field which depends on this field also gets null value.

so, i want to show the null values as zero value.

How can i do that.

please give me suggestions.

[buzzy996]

select ur expression and try this

[Gabriel]

Hi,

I would just wrap all the expression inside IF(ISNULL())

[#4]

hi Gabriel,

thanks for the reply.

i tried this, but its not working.

can u please help me with the complete expression?

[#5 · Accepted solution]

Hi,

maybe wrap your expression in a rangemax() function. That will ensure you have a value.

Rangemax(myexpressionhere,0)

hope that helps

Joe

[#6]

thanks a lot joe

[#7]

no problem glad to help