Can't get not equal to work

[#1]

Hi Community,

Below I have some code that attempts to find the number of open tickets:

count(

          {1<[Request Date Type] = {'Created'}>*<[Request Date Type]-={'Completed'}>}

          [Request Date Type]

)

For some reason I get a little squigle under the -={"Completed">}... of the code and it gives me all the values created but not subtracting those that are completed.

[Jason_Michaelides]

Try:

count(

          {1<[Request Date Type] = {'Created'}>*<[Request Date Type]={"='Completed'"}>}

          [Request Date Type]

)

[vgutkovsky]

Brandon,

Try set subtraction instead:

count({1<[Request Date Type] = {'Created'}>-<[Request Date Type]={'Completed'}>} [Request Date Type])

Vlad