and clause

[#1]

I'm trying to create an 'and' function and struggling.

I've got the basic code which is:

Count({<ExceptionMonth = {$(vCurrentMonth)}> } [Exception ID])

However i want to add another clause which is "and testID ='1'."

How / where would i do tis?

Cheers

[MK_QSL · Accepted solution]

Count({<ExceptionMonth = {$(vCurrentMonth)}, testID = {'1'}> } [Exception ID])

or

Count({<ExceptionMonth = {'$(vCurrentMonth)'}, testID = {'1'}> } [Exception ID])

[its_anandrjs]

Try with

Count({<ExceptionMonth = {' $(vCurrentMonth), testID = {'1' } '  }> } [Exception ID])

Or

Count({<ExceptionMonth = {' $(vCurrentMonth) '},  testID = {'1'}   }> } [Exception ID])

Regards

Anand