Feature Request: Round Up & Round Down
I'd love it if it were possible to have a round up / round down function. This is currently possible doing the following, but a dedicated function would be great:
IF X % 1 = 0
ELSE ROUND(X) + 0.5
The (+ 0.5) can be changed to (- 0.5) to round up or down accordingly.
I'm sure there are more, but for mine I calculate how many days are between the start of this past week and then divide the result by 7 to get a decimal week value.
DATE_DIFF(START_OF_WEEK_SUNDAY(TODAY()), [Ticket created - Date], "nb_of_days") / 7
If it were possible to round this up using a function, I could conveniently "snap" to week numbers, making simple filters much easier on reports when looking at specific weeks in the past.
Please sign in to leave a comment.