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.
Solved! Go to Solution.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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).
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
ah, thank you!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies