Ricerche recenti


Nessuna ricerca recente

Feature Request: Round Up & Round Down



Data ultimo post: 05 dic 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 commenti

Accedi per aggiungere un commento.

Non hai trovato quello che cerchi?

Nuovo post