Recent searches


No recent searches

Feature Request: Round Up & Round Down



Posted Dec 05, 2022

Hello,

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
THEN X
ELSE ROUND(X) + 0.5
ENDIF

The (+ 0.5) can be changed to (- 0.5) to round up or down accordingly.

 

Use Case

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.


0

0

0 comments

Please sign in to leave a comment.

Didn't find what you're looking for?

New post