Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be try this:
Count({$<JOBSTATUS={'Closed - Won'}>}JOBSTATUS)
Wow, it worked! Thanks so much Sunny!