issues pulling open cases for a specific customer

[Anonymous]

Hi All,

i have been having an issue getting a gauge bo9x to display the number of open cases for a specific customer. I have been using the following expression:

=SUM(IF([Customer]='company name' And statecode=0))

statecode is simply a marker for open cases.

I have trawled through the help manual and have no idea why this returns no results, if someone could point me in the right direction it would be most appreciated.

[adamdavi3s]

Its hard to advise without a bit more detail but firstly I can't see what you're actually trying to sum in your formula?

=SUM(IF([Customer]='company name' And statecode=0)opencases)

or try

Sum({<Customer={'Company name'},statecode={'0'}>}opencases)