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.
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.