In one of my clients' portals, we've built Custom SLA's for tickets. Now I'm trying to create a property 'Time until SLA breach', which is a difference between an actual time (ms) and a max time (ms) to work on a ticket. A workflow ensures this is expressed as either a negative or positive number.
Since it's shown in miliseconds, I figured I'd create a calculated property that multiplies it by 1 and shows it as a Duration. That works, except it isn't able to handle negatives. Seems to only be the case for Duration formatting. Selecting an (un)formatted number as output does show as a negative, but it would be fantastic if I could have something like:
-1 days, 4 hours
as the value. Basically the same that the Duration does now, but just with a negative sign in front of it.
... Mostrar más