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
Name | Value | Opt. | Description | Example |
---|---|---|---|---|
From | System.DateTime | - | Start of a user set timespan | - |
To | System.DateTime | - | End of a user set timespan | - |
Basic data | System.Double | - | Is a data column | - |
Queue column | System.String | opt. | Identifier column for queue processing | - |
Day type column | System.String | opt. | Identifier column for day types | - |
Settings
Name | Value | Opt. | Description | Example |
---|---|---|---|---|
Global absence rate | System.Double | - | If no absence rate for individual time periods has been defined the global absence rate is applied | 20.00 |
Name of the result column | System.String | - | The name of the column that this operation creates | "Result" |
Absence rate over the time period | System.String | opt. | These values overwrite the globally defined absence rates | - |
Rounding | System.Boolean | - | Determines if the results are whole-numbered | |
Threshold value for rounding off | System.Double | - | The threshold value used to round off | 0.4 |
Queue | System.String | opt. | Is only used for specific queues | - |
Precise time period | System.Boolean | opt. | Is only used for a specific time period | |
Beginning of the period | System.String | opt. | Start of the time period | "07/04/2022" |
End of the time period | System.String | opt. | End of the time period | "07/19/2022" |
Comment | System.String | opt. | A comment for additional Information | - |
Note | System.String | opt. | A short note | - |
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". |
---|---|
Settings | These are the settings |
Result |
|
Project File | - |
Troubleshooting
Nothing known up to now.