Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can do like this-
='GRAND TOTAL: ' & num(count({<[Prod]={'A'}>} DISTINCT Value) + count({<[Prod]={'B'}>} DISTINCT Value))
Please don't repost the same question again and again. Did you try the suggestion from this thread? -> Syntax in Text box