If a ticket goes into onhold status and say remains there for a week, when the ticket is finally marked as solved, does the full resolution time take into account the week it was onhold for?
Onhold affect full resolution time
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Unfortunately, the VALUE function cannot be used in the formula if non-database-level metrics are being used. More details about this here.
As a workaround, you may use something like this instead -