Good morning, an employee is attached to a particular cost centre code in our org. If they move to different department they are attached to new cost centre code.
Cost centres and the effective date are stored in two separate tables.
I have tried to use Maximum({Eff_Date}) but this gives the error "Boolean required"
I have a group for the cost centre code and one for the effective date but I cant seem to get a formula working using "Maximum" Does anyone have experience with this?