Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe like
=Count(Distinct F1) + Count({<B1 -= p(F1) >}Distinct B1)
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
And if you want to include a third discount field?