ROUND off the output | Community
Skip to main content
Kundanism
Kundanism
Level 10
Feb 25, 2022 12:25 PM UTC
Solved

ROUND off the output

Hi

Using this code to find Work Balance;

displayname=Work Balance

textmode=true

valueexpression=CONCAT(SUB({workRequired},{actualWorkRequired})/60," Hours")

valueformat=HTML

Possible to round off the output, right now it shows many digits after decimal.

Thanks in Advance.

Mvh

Kundan.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SarahNau
SarahNauAccepted solution
Employee
Feb 25, 2022 5:49 PM UTC

Hi Kundan,

You can try CONCAT(ROUND(SUB({workRequired},{actualWorkRequired})/60,2)," Hours")

Hope that helps!

View reply

6 replies

SarahNau
SarahNauAccepted solution
Employee
Feb 25, 2022 5:49 PM UTC

Hi Kundan,

You can try CONCAT(ROUND(SUB({workRequired},{actualWorkRequired})/60,2)," Hours")

Hope that helps!

Translate
    Kundanism
    KundanismAuthor
    Level 10
    Feb 28, 2022 8:28 AM UTC

    Thanks @Sarah Nau‚

    It works great. I donot know I tried the similar but no success. I was just wondering, can we include or highlight with red bold test if Work Balance is in negative.

    Any suggestion.

    Mvh

    Kundan.

    Translate
    SarahNau
    SarahNau
    Employee
    Feb 28, 2022 2:07 PM UTC

    Hey Kundan - you would have to have a calculated field on the task in order to use conditional formatting.

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...