Report to show reducing hours

[markTwo]

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

[Heather_Kulbacki]

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

[markTwo]

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