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". 
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