Report Design Formula Help

Question

Does anyone have a quick formula to calculate employees total hours worked by date (sum of regular, overtime and double-time)? 
 Any help is appreciated!

csedota · Accepted Answer

Set up a separate fomula for each pay ID and then total these together. For regular hours, the formula would be 
 IF(pay ID ="1", Units) 
 The record used is PR-Time. You would substitute the "1" with your specificic pay ID. 
 Once you have the three formulas set up, you can just create another formula that adds those three together.

Sage Construction & Real Estate

Report Design Formula Help

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING