ROUND off the output | Community
Skip to main content
Kundanism
Kundanism
Level 10
February 25, 2022
Solved

ROUND off the output

  • February 25, 2022
  • 1 reply
  • 1419 views

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.
Best answer by SarahNau

Hi Kundan,

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

Hope that helps!

1 reply

SarahNau
Adobe Employee
SarahNauAdobe EmployeeAccepted solution
Adobe Employee
February 25, 2022

Hi Kundan,

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

Hope that helps!

    Kundanism
    KundanismAuthor
    Level 10
    February 28, 2022

    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.

    SarahNau
    Adobe Employee
    SarahNauAdobe Employee
    Adobe Employee
    February 28, 2022

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

    Terms & ConditionsAccessibility statement

    Loading footer...