I received good advice about how I could create a custom field to display the total hours for each day of the week in the time card screen. As you can see below, I thought I got it to work properly; however, I keep running into an error message: Error: An error occurred during processing of the field Sat: Specified cast is not valid..
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/2ba1e040-28b7-424f-847c-30e42b8fdf85.png)
Mon Field:
>PXTimeList]
PXDBInt]
tPXFormula(null, typeof(SumCalc<EPTimeCardExt.usrMondayTotal>))]
)PXUIField(DisplayName = "Mon")]
Monday Hours:
:PXInt]
tPXTimeList(30, 335, ExclusiveValues = false)]
)PXUIField(DisplayName = "Monday Hours", Enabled = false)]
Also tried PXDBInt for Monday hours.
Could I be getting this error message because how Time spent field is being calculated is the following?
/PXInt]
tPXTimeList]
tPXDependsOnFields(typeof(mon), typeof(tue), typeof(wed), typeof(thu), typeof(fri), typeof(sat), typeof(sun))]
)PXUIField(DisplayName = "Time Spent", Enabled = false)]
Not the biggest issue if I can’t get this to work, just wanted to add something to the time sheet for colleagues.
Any advice would be greatly appreciated :)