Syntax for distinct count using alternate states

[#1]

I am having a hard time coming up with the correct syntax for this simple calculation...

I need to do a distinct count of Seq #'s in Alternate State A and Alternate State B.

Here is what I've got...

=count({StateA} Distinct [Seq#]

Simple but it's not affected by the default state filters and I want it to be.

What do I need to add to make this formula work with other filters?

Thanks in advance:)

[crusader_]

Hi,

Try this one:

=count({$*StateA} distinct [Seq#])

Regards,

Andrei Kaliahin

[sagarkharpude]

Check this:

count({[Group1]}DISTINCT [Seq#])

[#4]

This worked! Thank you!

[#5]

This didn't work for me. I think you need the $* to listen to all other filters.

[sagarkharpude]

Hi,

If the issue is resolved, Marked it as correct answer.