Count If Set Analysis

[khaycock]

I have an expression that I am trying to combine set anaylsis and a count if, but I can't seem to get the combination right. These are the two separate expressions that I am trying to combine:

=Count({<PART_NUMBER-={"''"}>}NEED_BY_DATE)

=count(if(NEED_BY_DATE < date(today()),0))

Any ideas?

[agigliotti · Accepted solution]

maybe this:
=Count( {< PART_NUMBER -= {"''"} >} if( NEED_BY_DATE >= date(today()), NEED_BY_DATE ) )
Regards

[its_anandrjs]

Hi,

You can try this also with complete SET analysis statement

=Count( {< PART_NUMBER -= {"''"},  NEED_BY_DATE ={">=$(=date(today( )) )"}  >}  NEED_BY_DATE  )

Regards,

Anand