I know this is an old thread, but I was searching for a solution and stumbled on my own question :)
I have a different scenario requiring the same formula. In this case, I am creating a Summary Report, with a Report Formula containing the above, to DISTINCT count the number of items in the text list.
It's working great, except for one detail: It's counting the empty values. Is there a way to adjust the above formula to avoid the empty values?
I have tried the Nz() but that didn't seem to do the trick.
I also tried to add an if statement on each Trim Line
If(Trim(Part($value,1,";")) <> "", Trim(Part($value,1,";")),"")
That also didn't seem to work.
Any other ideas?
------------------------------
George Khairallah
CTO
gotomyerp, LLC
------------------------------
