Text Code for Assignement Breakdown?

[Kundanism]

Hi,

Since expert in text code; so looking for a favour. We use assignment breakdown as column in project view, the code is;

displayname=Assignment Breakdown

listdelimiter=<br>

listmethod=nested(assignments).lists

textmode=true

type=iterate

valueexpression=CONCAT({assignedTo}.{name}," (",{role}.{name},") - ",{workRequired}/60,IF({workRequired}/60>ABS(1)," Hours"," Hour"))

valueformat=HTML

Id planned hours is 40 hrs equally between 3 assigments, then the planned hour shows 13.3333333 hrs each.

Any solution to round this number?????

Thanks in advance.

Mvh

Kundan

[Richard_Le_ · Accepted solution]

Hi Kundan,

Adding ROUND function to your value expression would enable you to do this. See updated code below where we are rounding to 2 decimal places. If you wanted to round to a different number of decimal places, simply change the 2 highlighted in bold to how many decimal places you need.

displayname=Assignment Breakdown

listdelimiter=<br>

listmethod=nested(assignments).lists

textmode=true

type=iterate

valueexpression=CONCAT({assignedTo}.{name}," (",{role}.{name},") - ",ROUND({workRequired}/60,2),IF({workRequired}/60>ABS(1)," Hours"," Hour"))

valueformat=HTML

Best Regards,

Rich.

[Kundanism]

Thanks a lot @Richard Leek‚ . It works great.

Mvh

Kundan.