Expression in Text box

[#1]

Hi,

Please let me know what is missing in the below statement:

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

The 'Grand Total' and the expression are working fine individually but not together as shown above.  Please let me know if I am missing something in the syntax.

Thanks,

Sudha.

[Digvijay_Singh]

You can do like this-

='GRAND TOTAL: ' &  num(count({<[Prod]={'A'}>} DISTINCT Value) + count({<[Prod]={'B'}>} DISTINCT Value))

[sunny_talwar]

Please don't repost the same question again and again. Did you try the suggestion from this thread? -> Syntax in Text box