Report to show reducing hours | Community
Skip to main content
M
markTwo
Level 2
September 8, 2023
Question

Report to show reducing hours

  • September 8, 2023
  • 1 reply
  • 594 views

Hi guys, I feel this should be really easy but I'm struggling.  I'd like to run task based report which shows a reducing total based on planned or actual hours and reduces based on a static number ( 56 hours) per month. Ideally I wanted to contain this to a report rather than a caculated field. 

 

Thanks

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Heather_Kulbacki
Community Advisor
Heather_KulbackiCommunity Advisor
Community Advisor
September 8, 2023

You'll need some text mode. Try something along this line to get started:

 

displayname=Column Name Here
textmode=true
valueexpression=SUB(56,{actualWork})
valueformat=HTML

actualWork = Actual Hours
I can't remember if actualWork comes through as hours or minutes, if it's minutes you may need some extra math:

displayname=Column Name Here
textmode=true
valueexpression=SUB(56,({actualWork}/60))
valueformat=HTML

 

workRequired = Planned Hours

 

    M
    markTwoAuthor
    Level 2
    September 8, 2023

    Thanks Heather, much appriciated, I'll start with this and see how it goes. 

    Terms & ConditionsAccessibility statement

    Loading footer...