?

[xyz1]

.

[pradosh_thakur · Accepted solution]

May be this

Count ({<DIGIC = -{"Yes"},[Is in MP]={"Yes"}>} distinct [NAME OF PROJECT (Code - Title)])

[srivastalans]

Hi Agrim,

Try this,

Count ({<DIGIC -= {"No",""},[Is in MP]={"Yes"}>} distinct [NAME OF PROJECT (Code - Title)])

You should add sign in-front of equal sign for DIGIC to exclude NO and Blank.