How to convert currentStatusDuration to days in calculated column in textmode?

[KristinaN]

Hello, I am looking to convert the developer object currentStatusDuration to days instead of hours as is default. When I run the below it is giving 0's so I think it is close but something must be off in my code. 

displayname=Days in Status
textmode=true
valueexpression=DIV({currentStatusDuration},24)
valueformat=double

[Sven-atClient]

Hi @KristinaN 

try this? 

displayname=Days in Status
textmode=true
valueexpression=round({currentStatusDuration}/24,1)
valueformat=doubleAsDouble

[KristinaN]

Thank you so much, that ends up yielding 0.00 instead of just 0 but unfortuantely not doing any sort of calculation. Thanks!

[Sven-atClient]

displayname=Days in Status
textmode=true
valueexpression=round({currentStatusDuration}/24,1)
valueformat=string

what about using string as format? 

[KristinaN]

That one yields just a 0 for all the items. 

[Sven-atClient]

can you use just the field and report what it shows

valuefield=currentStatusDuration

What is the report on? Task, status? 

[KristinaN]

Okay so it is on a report of Issues. I submitted a ticket with Adobe and they advised trying the below instead because the currentStatusDuration is a dynamic field. However this is yielding wonky results but at least it is not 0! 

It seems this gives minutes and converts to days but for the first line it has been 2 years since the update was made.

displayname=Days in Status
textmode=true
valuefield=currentStatusDuration
valueformat=compound#M:D

[AmyReilly]

If you change the valueformat to compound#H:D, it gets closer.  However, the currentStatusDuration counts hours on a 24-hour basis, and this line of code converts the hours over to an 8-hr day.  

So, if a request is in a status for 30 hrs, that column should show up as 1.25 days  (30/24).  Instead, it shows up as 3.75 days (30/8).

[KristinaN]

I see, we definitely want it in 24 hours not 8 hour increments for days. Is there another way to convert instead of compound to account for the correct increments?

[Sven-iX]

@KristinaN I am so sorry to have misled you here. I am not sure what I saw but you're right; valueexpression won't work at all. 
Looks like there is no option outside displaying hours, or workdays. I was hoping there is a "weekdays" version of the compound format but can't find anything. 

[Sven-iX]

So the duration seems to come in as expected now. 

per Amy's comment, you could try this: 

valueexpression=round({currentStatusDuration}/24,1)+" Days"
valueformat=HTML

[KristinaN]

When I try to use valueexpression like the above it just gives me a blank in that field. It sounds like I can't use currentStatusDuration with valueexpression at all.

[kautuk_sahni]

@KristinaN just checking in! Were you able to get this resolved? If one of the replies above helped—whether it completely solved the issue or simply pointed you in the right direction—marking it as accepted can make it much easier for others with the same question to find a solution. And if you found a different way to fix it, sharing your approach would be a great contribution to the community. Your follow-up not only helps close the loop but also ensures others benefit from your experience. Thanks so much for being part of the conversation!