Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i need to calculate how many letters are not read more than five days with tow conditions:
status field (ISREAD= 0)
and the difference between received day and system date in days is more than 5 ([D_DIFF])> 5)
i tried this expression but i need some help to correct it
if((ISREAD= 0) and ([D_DIFF])> 5,count(DISPLAYNUMBER))
Try this
COUNT({<ISREAD={0}, [D_DIFF]={'>5'}>} DISPLAYNUMBER)