Capturing ( by percent ) total weekly time by user against contracted hours | Community
Skip to main content
M
MarcFl1
November 11, 2021
Question

Capturing ( by percent ) total weekly time by user against contracted hours

  • November 11, 2021
  • 1 reply
  • 459 views

Hi All

Im trying to find a way to capture ( by percent ) total weekly time by user against their contracted weekly hours ( 37.5 ).

I've created a Timesheet report which captures the total weekly hours ( timesheet:totalHours ) and also a user custom form that details the users contracted weekly hours. What I cant seem to do is work out how to create a custom column give me a percent value - I'm thinking (timesheet:totalHours/DE:WeeklyCapacityHours*100 ).

I've looked at a custom forms as well but theres no opting to create a calculated field for timesheets ( very very annoying ).

Has anyone done anything similar or have any advice/guidance?

Marc

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

1 reply

ChrisBudgen
ChrisBudgen
Level 5
November 15, 2021

Hi @Marc Fletcher‚ ,

we are using Fusion (you could use the API as well), to calculate the weekly normtime/capacity and then store that value in the extRefID field of the timesheet. You can then use that on a timesheet report or timesheet list to calculate the value. Here for example the missing normtime:

displayname=Missing Norm Time

textmode=true

valueexpression=IF(ISBLANK({extRefID})=false,SUB({totalHours},NUMBER({extRefID})),"")

valueformat=doubleAsDouble

Hope this helps!

Chris

Terms & ConditionsAccessibility statement

Loading footer...