Set Analyis Not Working: Only Include These Values

[#1]

Hello all,

I work for a large company that closes deals on orders. Every time the order is closed and won, the job status switches to 'Closed - Won'. I'm trying to make a chart would would only include these values, but I'm having a hard time understanding why my set analysis isn't working.

Here's the expression I'm trying to use:

TextCount({$<JOBSTATUS={$(='Closed - Won')}>}JOBSTATUS)

If anyone can provide any help, that would be greatly appreciated!

[sunny_talwar · Accepted solution]

May be try this:

Count({$<JOBSTATUS={'Closed - Won'}>}JOBSTATUS)

[#3]

Wow, it worked! Thanks so much Sunny!