Project Report: Display Project Actual Duration without "Days"

[mvsteep]

Could someone share the text mode needed to display the Project Actual Duration without "Days" in the result? This will save us a step in excel so we don't need to delete all the "days" in this column.

[Madalyn_Destafney]

Not able to test this out at the moment but try messing with the value format in text mode of that column. Instead of HTML maybe numberasstring, can’t remember what it would be. Find the value format of another column that is number only and use that for context and see if that works.

If can’t get it, in your excel you can easily do a bulk find & replace to replace “Days” with “ “ (a space).

[mvsteep]

didn't work, looks like the system keeps reverting back the value format to it's original form, "compound#M:D":

displayname=Actual Duration (no days)
linkedname=direct
namekey=actualduration
querysort=actualDurationMinutes
textmode=true
valuefield=actualDurationMinutes
valueformat=compound#M:D
viewalias=actualduration

[Sven-iX · Accepted solution]

Hi @mvsteep 

use valueexpression and do the calculation manually: get the minutes, divide by 60 (hours), then 8 (days) and round to 2 decimals.

valueexpression=round({actualDurationMinutes}/60/8,2)
linkedname=direct
valueformat=string
displayname=Actual Duration (no days)
namekey=actualduration
textmode=true
querysort=actualDurationMinutes
viewalias=actualduration

[mvsteep]

ah, thank you!