Set Analysis Expression.

[grajmca_sgp123]

I would like to replace '-' with '0' in above set analysis expression.

Syntax which I used but didn't workout.

If(
len(count({<Flag<>{'F'}>}distinct(ID)))='0',0,count({<Flag<>{'F'}>}distinct(ID))
)

[DavidM]

If you want to exclude items with Flag F, you're doing it wrong, you can't use <>

either use -= or Flag={*}-{'F'}

[puneetagarwal]

Use below expression:

If(
len(count({<Flag-={'F'}>}distinct(ID)))='0','-',count({<Flag-={'F'}>}distinct(ID)))

I hope it works.

Regards,
Puneet Agarwal