Unique Count from 2 different fields in single expression

[#1]

Hi All,

So this is the issue, i have to show unique count from 2 separate fields in a single text box.

The confusion is how to find distinct value from 2 columns in single expression.

I have created a POC, 2 columns are F1 and B1, also i have also got a solution to it but i think by doing that my application could get super loaded(getting all values in a variable and values can go into millions).

PFA poc and let me know if there is any other simple way to do this.

Thanks,

ASP

[swuehl · Accepted solution]

Maybe like

=Count(Distinct F1) + Count({<B1 -= p(F1) >}Distinct B1)

[#3]

Yes this works too, thanks Swuehl..

Just one query this wouldn't be too heavy to use right, i stressing on this is because already my application has grown very much

[rolandies]

And if you want to include a third discount field?