Isnull() function in Pivot table

[muniyandi]

Hi All,

I'm using pivot table, my requirement is monthwise sales .if currect month sales is zero or null means, to carry last month sales.

if(Column(1)=0,Before(Column(1)),sum(sales))  /*Working Correctly */

But:

if(isnull(column(1)),Before(Column(1)),sum(sales)) /* Not Working */

What's the reason using isnll() function entire row getting null ?

Required Expression :

if(( isnull(column(1)) or Column(1)=0),Before(Column(1)),sum(sales))

Thanks,

Muni

[muniyandi]

hi ,

anybody help to me

[Anonymous]

HI,

with column() you are adressing the content of your current row for the specified column. Depending on your expression in Column 1 it will not return null even if data is null. For example sum always returns 0, even if you sum null values. This maybe the reason why isnull() will not work on column(1).

Best

Stefan

[muniyandi]

Hi Stefan,

Thanks For reply,

My data have null value , how to deal null and zero values. in my expression .

[#5]

try this

if(( column(1)=null() or Column(1)=0),Before(Column(1)),sum(sales))