Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be try this:
='Grand Total: ' & (Count({<[FLAG1]={'E'}>} DISTINCT TEST_CASE_ID) + Count({<[FLAG1]={'C'}>}DISTINCT TEST_CASE_ID))