Summary

With this operator it is possible to round off a number and add a from the user set percentage to one or more identifiers for a specific time span.

Important use case: Absence rate.

Configuration

Input settings of existing table

Settings

Remarks

Be careful when calculating percentages e.g. 20% absence rate leads to an additional 25%. (Difference: percentage OF <> percentage TO> - so it the percentages won't be doubled)

Vorsicht bei Prozentsatzrechnung: zB 20% Abwesenheit führt zu 25% Aufschlag (Differenz: Prozent VON <> PROZENT AUF> - damit nicht doppelt aufgeschlagen wird.


Want to learn more?

Screenshot


Examples

Example: Absence quota without rounding

Situation

A surcharge should be given to the column "data". 
Die Spalte Daten soll mit Zuschlag versehen werden


Settings

These are the settings

Result

  • The column data hes been increased by 25% in order to have a 20% Reserve for absences.
  • There has been no rounding done.

  • Es wurde durchgehend um 25%(!) erhöht, um eine Reserve für 20% Abwesenheit zu haben
  • Keine Rundung

Project File

-


Troubleshooting

Nothing known up to now.


Related topics