Hi all,
The scenario I have is a person can have one or more charges on his/her case.
One charge could be GUILTY and the other charge
is DROPPED. If this is the scenario, I would like to assign GUILTY Adjudication to this case
OR
One charge could be WITHHELD and the other charge is DROPPED.
If this is the scenario, I would like to assign WITHHELD to this case
I would like to create a formula field that would assign either GUILTY, WITHHELD, etc.
Sample data:
12345 GUILTY (For this case, formula field should be Guilty)
12345 DROPPED
98765 WITHHELD (For this case, formula field should be WITHHELD)
98765 DROPPED
I would like to go through all charges for each case. If a case has at least one GUILTY or at least one WITHHELD, I like to assign GUILTY or WITHHELD on this formula field.
Any help is greatly appreciated.
IP Logged
