Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
maybe wrap your expression in a rangemax() function. That will ensure you have a value.
Rangemax(myexpressionhere,0)
hope that helps
Joe
select ur expression and try this
Hi,
I would just wrap all the expression inside IF(ISNULL())
hi Gabriel,
thanks for the reply.
i tried this, but its not working.
can u please help me with the complete expression?
Hi,
maybe wrap your expression in a rangemax() function. That will ensure you have a value.
Rangemax(myexpressionhere,0)
hope that helps
Joe
thanks a lot joe
no problem glad to help