Syntax in Text box

[#1]

Hi,

Please correct the below syntax.  It's not working.

='Grand Total: ' &count(
{<
[FLAG1]={'E'}
>}
DISTINCT TEST_CASE_ID) +
count(
{<
[FLAG1]={'C'}
>}
DISTINCT TEST_CASE_ID)

Here, 'Grand Totat' alone is working fine or the expression part alone is working fine.  However, I couldn't combine both and get the results..

Thanks,

Sudha.

[sunny_talwar]

May be try this:

='Grand Total: ' & (Count({<[FLAG1]={'E'}>} DISTINCT TEST_CASE_ID) + Count({<[FLAG1]={'C'}>}DISTINCT TEST_CASE_ID))