<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: ROUND off the output in Workfront Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/round-off-the-output/m-p/481340#M14116</link>
    <description>&lt;P&gt;Hey Kundan - you would have to have a calculated field on the task in order to use conditional formatting. &lt;/P&gt;</description>
    <pubDate>Mon, 28 Feb 2022 14:07:52 GMT</pubDate>
    <dc:creator>SarahNau</dc:creator>
    <dc:date>2022-02-28T14:07:52Z</dc:date>
    <item>
      <title>ROUND off the output</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/round-off-the-output/m-p/481337#M14113</link>
      <description>&lt;P&gt;Hi&lt;/P&gt;&lt;P&gt;Using this code to find Work Balance;&lt;/P&gt;&lt;P&gt;displayname=Work Balance&lt;/P&gt;&lt;P&gt;textmode=true&lt;/P&gt;&lt;P&gt;valueexpression=CONCAT(SUB({workRequired},{actualWorkRequired})/60," Hours")&lt;/P&gt;&lt;P&gt;valueformat=HTML&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Possible to round off the output, right now it shows many digits after decimal.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Thanks in Advance.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Mvh&lt;/P&gt;&lt;P&gt;Kundan.&lt;/P&gt;</description>
      <pubDate>Fri, 25 Feb 2022 12:25:17 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/round-off-the-output/m-p/481337#M14113</guid>
      <dc:creator>Kundanism</dc:creator>
      <dc:date>2022-02-25T12:25:17Z</dc:date>
    </item>
    <item>
      <title>Re: ROUND off the output</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/round-off-the-output/m-p/481338#M14114</link>
      <description>&lt;P&gt;Hi Kundan,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;You can try CONCAT(ROUND(SUB({workRequired},{actualWorkRequired})/60,2)," Hours")&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Hope that helps!&lt;/P&gt;</description>
      <pubDate>Fri, 25 Feb 2022 17:49:33 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/round-off-the-output/m-p/481338#M14114</guid>
      <dc:creator>SarahNau</dc:creator>
      <dc:date>2022-02-25T17:49:33Z</dc:date>
    </item>
    <item>
      <title>Re: ROUND off the output</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/round-off-the-output/m-p/481339#M14115</link>
      <description>&lt;P&gt;Thanks @Sarah Nau‚ &lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;Any suggestion.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Mvh&lt;/P&gt;&lt;P&gt;Kundan.&lt;/P&gt;</description>
      <pubDate>Mon, 28 Feb 2022 08:28:21 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/round-off-the-output/m-p/481339#M14115</guid>
      <dc:creator>Kundanism</dc:creator>
      <dc:date>2022-02-28T08:28:21Z</dc:date>
    </item>
    <item>
      <title>Re: ROUND off the output</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/round-off-the-output/m-p/481340#M14116</link>
      <description>&lt;P&gt;Hey Kundan - you would have to have a calculated field on the task in order to use conditional formatting. &lt;/P&gt;</description>
      <pubDate>Mon, 28 Feb 2022 14:07:52 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/round-off-the-output/m-p/481340#M14116</guid>
      <dc:creator>SarahNau</dc:creator>
      <dc:date>2022-02-28T14:07:52Z</dc:date>
    </item>
    <item>
      <title>Re: ROUND off the output</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/round-off-the-output/m-p/481341#M14117</link>
      <description>&lt;P&gt;Hi @Sarah Nau‚ &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I have added the below as calculated field on the task level view;&lt;/P&gt;&lt;P&gt;displayname=Work Balance&lt;/P&gt;&lt;P&gt;textmode=true&lt;/P&gt;&lt;P&gt;valueexpression=CONCAT(ROUND(SUB({workRequired},{actualWorkRequired})/60,2)," Hours")&lt;/P&gt;&lt;P&gt;valueformat=HTML&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;B&gt;But unable to figure out, that how to highlight with red bold if Work Balance is in negative.&lt;/B&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Possible to get hep in this regard.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Mvh&lt;/P&gt;&lt;P&gt;Kundan.&lt;/P&gt;</description>
      <pubDate>Mon, 07 Mar 2022 09:49:04 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/round-off-the-output/m-p/481341#M14117</guid>
      <dc:creator>Kundanism</dc:creator>
      <dc:date>2022-03-07T09:49:04Z</dc:date>
    </item>
    <item>
      <title>Re: ROUND off the output</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/round-off-the-output/m-p/481342#M14118</link>
      <description>&lt;P&gt;Hi Kundan -&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;On your report, in the columns (view) area, click on the new column for Work Balance. In the upper right, click on advanced options, then click on Add a Rule for this Column. Set up the rules - Work Balance is less than 0, then choose your text format and red background. Click on Add Rule, then save and close.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0694X00000I8oVLQAZ.png"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/44777i65BCE54D904F822E/image-size/large?v=v2&amp;amp;px=999" role="button" title="0694X00000I8oVLQAZ.png" alt="0694X00000I8oVLQAZ.png" /&gt;&lt;/span&gt;Hope that helps!&lt;/P&gt;</description>
      <pubDate>Mon, 07 Mar 2022 14:48:49 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/round-off-the-output/m-p/481342#M14118</guid>
      <dc:creator>SarahNau</dc:creator>
      <dc:date>2022-03-07T14:48:49Z</dc:date>
    </item>
    <item>
      <title>Re: ROUND off the output</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/round-off-the-output/m-p/481343#M14119</link>
      <description>&lt;P&gt;Thanks a lot @Sarah Nau‚ . Excellent. It works.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Mvh&lt;/P&gt;&lt;P&gt;Kundan.&lt;/P&gt;</description>
      <pubDate>Tue, 08 Mar 2022 20:28:39 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/round-off-the-output/m-p/481343#M14119</guid>
      <dc:creator>Kundanism</dc:creator>
      <dc:date>2022-03-08T20:28:39Z</dc:date>
    </item>
  </channel>
</rss>

