1 of 1 people found this helpful
That depends on which version of the software you're using. From 7.3 onwards it's possible to do it with a calculation, for some help with that you'll need to contact Support or ask your Consultant. If you're on an earlier version then your Consultant can provide a trigger to replicate the behaviour you need.
We're on 7.2.5 so I'll raise a support cal for the request