Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello:
I'm trying to add a Count to a straight table chart / window title using the following:
=if(Phase = 'Finance Validation',Count (ID)) & ' OUTSTANDING FINANCE VALIDATIONS'
When I click Apply, the only thing that is returned for the Chart Title is OUTSTANDING FINANCE VALIDATIONS. The Count should equal 85. I'm guessing I'm missing something simple. Any ideas?
As always, thanks in advance for any and all help.
Try this way?
Count({<Phase = {'Finance Validation'}>} ID) & ' OUTSTANDING FINANCE VALIDATIONS'
Try this way?
Count({<Phase = {'Finance Validation'}>} ID) & ' OUTSTANDING FINANCE VALIDATIONS'
Thank you Anil for the response. This works. Why would my syntax not work? I’m not looking for a long explanation. Just simply curious. I will mark your answer as the correct answer. Thank you for your help. I appreciate it.
Your syntax pretty works when you got filter from Phase as "Finance Validation" only until unless it won't..
Ah. Ok. Thank you and thanks again for your help.