Weekly day-field totals for billable rows (IsBillable = true) without grouping the main grid

Hi ​@KCHEKURI ,

Would you share your expected resulting view in the table format? Ideally with a numeric example.

Thank you!

Hi ​@Adelina Basyrova In a Generic Inquiry, I want to display a row “the way it looks on the last line number,” i.e., only the record where EPTimeCardSummary.LineNbr is the maximum for a given key. I’d like to do this without changing my row layout or grouping the main grid.

​@KCHEKURI , time card summary (EPTimeCardSummary) doesn’t have the week so you might need to pull it from the time card (EPTimeCard)). 

With the generic inquiry you can calculate the time card summary line total total billable/non-billable:

If some of your configuration doesn’t give the expected result, feel free to report a support case.

Thank you!

​@Adelina Basyrova 

Hi Adelina,

I’m working on a calculated field where, if the day of the week is Sunday, it should return the total Sunday hours for that week without grouping . For example, in week 202421, the total Sunday hours are 10, and I need that value to appear in the new calculated field.

Have you considered using a pivot table to achieve what you’re looking for?

I like to use PMTimeActivity to get the time data as it should have a column called DayOfWeek (which gives you a 0=Sunday, 7=Saturday) and you get the billable/nonbillable info.
 

​@meganfriesen37 Since the timesheet data keeps increasing (it’s already more than 90,000 records), creating a pivot isn’t that easy. Until now I’ve been using EPTimeCard, but I’ll give PMTimeActivity a try.

​@meganfriesen37 What I really need is a way to build the report without using Pivot and without grouping — just pulling the raw activity data in a flat layout so I can calculate on top of it. I tried creating a pivot, but it’s not that easy to manage with the growing timesheet data. 

Thanks.

Hi ​@KCHEKURI were you able to find a solution? Thank you!