Expand my Community achievements bar.

SOLVED

Project Report: Display Project Actual Duration without "Days"

Avatar

Level 2

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.

1 Accepted Solution

Avatar

Correct answer by
Level 4

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

 

View solution in original post

4 Replies

Avatar

Community Advisor

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).

If this helped you, please mark correct to help others : )

Avatar

Level 2

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

Avatar

Correct answer by
Level 4

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