...
2. Parameter Reference Table
| Parameter | Description | Correct Use | Do NOT Use When |
|---|---|---|---|
| Absence Days | Number of absent working days | Reducing day-based payments | Calculating hourly salary |
| Absence Hours | Number of absent hours | Reducing hour-based payments | Calculating day-based salary |
| Days In Period | Total days in the period | Denominator for proportional logic (if justified) | Replacing Norm Days without reason |
| Days Worked | Actual worked days | Monthly salary proration | Hour-based formulas |
| Fixed Amount | Fixed value | Allowances, bonuses, deductions | Without proration logic if required |
| Hours Worked | Actual worked hours | Hourly salary calculation | Day-based salary |
| Hours Worked by Jobs | Hours per job/project | Multi-job or project payroll | Simple single-job payroll |
| Norm Days | Standard working days | Monthly salary base | Hour-based calculations |
| Norm Days by Schedule | Norm days per employee schedule | Shift / flexible schedules | Fixed schedules |
| Norm Hours | Standard working hours | Hourly & overtime base | Day-based formulas |
| Overtime Hours | Hours beyond norm | Overtime calculation | Regular salary |
| Sales Amount | Total sales value | Turnover-based commission | Margin-based commission |
| Sales Margin | Profit from sales | Margin-based commission | Turnover-based commission |
| Tariff | Salary rate (daily/hourly/monthly) | Base of all calculations | When unit does not match formula |
...
3. Recommended Formula Patterns
...
4. Frequent Formula Errors (and How to Avoid Them)
...
Mixing Days and Hours
Incorrect:
Tariff × Hours Worked / Norm Days
Correct:
Use hours with Norm Hours, days with Norm Days.
...
Using Absence Days and Absence Hours Together
This leads to double reduction.
✔ Choose one unit only, based on how the salary is calculated.
...
Using Days In Period Instead of Norm Days
This may distort salary calculations.
✔ Use Norm Days unless there is a documented business reason.
...
Incorrect Tariff Unit
Example:
Hourly tariff × Days Worked
✔ Always match tariff unit with calculation unit.
...
Fixed Amount Without Proration Logic
This may overpay or underpay in partial months.
...
accurate payroll and commission calculations;
predictable system behavior;
transparency for audit and reconciliation.
Thank you for being FIRSTBit customer!