Match

[ramprakashs]

Hi When applying the following query i should get the count of projects but I am getting '-'

IF(MATCH(CONTRACTSTAGE, '30 / Pre-Tender'), Count(distinct PROJECTID))

Please correct me my mistake.

Thanks in advance.

[ramprakashs]

I am attaching the output file for your reference.

[sugathirajkumar]

Please check the spelling of small in your data ..it was metioned as samll

[ramprakashs]

Hi Thanks I got the desired output.