Count IF

[upaliwije]

Hi Friends

I have a pivot table with following fields

Item_No, Purchase Date....

I want to create a expression to count item no if purchase date is not null

Count(Item_No)  how can I include condition    'IF PURCHASE DATE IS NOT NULL'

pla help me

[cgdonders · Accepted solution]

Hi,

You can use the isnull() function for this:

Count( IF(isnull(purchase date)=0, item no) )

Isnull: 0 if field is not null, -1 if field is null

[swuehl]

Maybe

=count( if(len(trim([Purchase Date])), Item_No))

But to understand your problem correctly, it might be helpful if you could upload a small sample application.

[upaliwije]

Thanks a  lot to both of you