Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to count how many RxNo are the same and the only display the ones that have a count of one?
Count((RxNo) and (RxNo) = '1')
May be this:
Count({<RxNo = {"=Count(RxNo) = 1"}>}RxNo)