Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
You can try this also with complete SET analysis statement
=Count( {< PART_NUMBER -= {"''"}, NEED_BY_DATE ={">=$(=date(today( )) )"} >} NEED_BY_DATE )
Regards,
Anand