Dear all,
Howdy, got a query which should hopefully be a quick one. I thought it would already have been asked here, but I couldn't find a similar query via the search, so here goes.
I have a formula (@AssignedWorker), correctly selecting a Worker assigned to specific clients. Trying to choose which worker is based on three logicals, and looks roughly like this:
if not isnull({Review.WorkerName}) then {Review.WorkerName} else
if not isnull({Referral.WorkerName}) then {Referral.WorkerName} else
NthMostFrequent (1, {Events.WorkerName}, {Episode.Episode})
This is correctly finding the worker I'm looking for in each case.
Now, I want to group on this output. And I can't find the reference to the formula I've created to group against (accessing the Group Expert, the formula created is not available).
HELP! Pretty please.
IP Logged
