Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm still a bit unclear about what your data looks like. Is this part of the original question? If it is then you are able to mix set analysis with what I posted, so
Count(<{obj_type_code={‘CHB’,’BBF’},app_gc=P(app_gc1)> distinct If(FieldA = FieldB, inv_no ))
Is a valid statement. Is there data you can post to explain further?
The simplest way to do this is
Count( If(FieldA = FieldB, Value))
You can also use set analysis, but this works and is simpler.
I'm still a bit unclear about what your data looks like. Is this part of the original question? If it is then you are able to mix set analysis with what I posted, so
Count(<{obj_type_code={‘CHB’,’BBF’},app_gc=P(app_gc1)> distinct If(FieldA = FieldB, inv_no ))
Is a valid statement. Is there data you can post to explain further?