Calculations

If you already know what you are looking for, please use the browser's built-in search function which you can access via CTRL + F, then type the formula into the search field.


No formula
When no formula is used, values in the column are reported manually.


%

Used to calculate a percentage of something. When you select the formula, two new rullgardinslistor are displayed:

  • Value column – Select the numerator i.e. Number up at division.
  • Target column -Here you select the denominator i.e. Number down at division.

columns = (100 * Value column)/Target column

At division by 0, no value is written. If you want to print 0 or 100, select % (division by 0 gives 0) Or % (division by 0 gives 100).


(/100 *)
When you select the formula, two new rullgardinslistor are displayed:

  • Value column -Here you select the number to be shared with 100.
  • Target column -Selects the number to multiply.

Columns = (Value column/100) ' Target column


*
Used to multiply values from two columns i.e. To get a product from two factors. When you select the formula, two new rullgardinslistor are displayed:

  • Value column – Select the column from which to retrieve the first factor.
  • Target column -Selects the column to retrieve the second factor from.

columns = Value column* Target column


/(division by 0 gives 0) And /(division by 0 gives 100)
Used to divide values from two columns and thus obtain a quota. When you select the formula, two new rullgardinslistor are displayed:

  • Value column – Select the column whose values you want to share.
  • Target column -Here you select the column whose values you want to share with.

columns = Value column/Target column

Select whether you want the division by 0 to give the result 0 or 100.


/ 1000
Used to divide a value by 1000. When you select the formula, a new drop is displayed:

  • Value column -Here you select the column whose values you want to share with 1000.

columns = Value column/1000


/ 1M
Used to divide a value by 1 million. When you select the formula, a new drop is displayed:

  • Value column -selects the column whose values you want to share with 1m.

columns = Value column/1 000 000


100 - %
Used to calculate a percentage variance. When you select the formula, two new rullgardinslistor are displayed:

  • Value column – Select the numerator i.e. Number up at division.
  • Target column -Here you select the denominator i.e. Number down at division.

columns = 100-((100 * Value column)/Target column)


Absolute Target fullfilment%
Used if you only want the 100% shown if the target is fully met, both up and down. Gender equality measures. The value can never exceed 100%. If the outcome of the target is Negative Target fullfilment and sub-targets are used Target fullfilment.

  • Value column – Select from which column in the measure the outcome value used to calculate absolute target fulfillment should be retrieved.
  • Target column -Select from which column in the measure the target value used to calculate absolute target fulfillment should be retrieved.

Column = See target achievement and negative target achievement.


Absolut value
Used to retrieve a value from another column. The difference against the formula Identity Is that absolute value does not take into account whether the values are negative, ie. No minus sign is written in front of the values that are retrieved. The purpose of this is that if you want to make a calculation where, for example, you want to get a quota and instead of it says that the quota is – 25%, you can MHA Absolutbeloppsformeln get it to the quota is 25% (positive value). When you select the formula, the drop-down list appears:

  • Value column — selects the column from which to retrieve values.

Column = Abs (bleed column)


Accumulated
Used to accumulate values i.e. Continuously add all values that are reported in a column. When you select the formula, the drop-down list appears:

  • Value column – Select the column whose values you want to accumulate.

(to accumulate only the values during the year, the formula is accumulated per year.)
column = SUM (bleed column first entered: Bleed column column date)


Accumulated per half-year/quarter/term/fiscal year/trimester/trimester variant/year
Used to calculate an accumulated value within the time period. For example, if the measure has månadsperiodicitet, the formula can be used to show at each month an accumulated value for what was reported during that time period. When you select the formula, the drop-down list appears:

  • Value column – Select from which column the values of the time period will accumulate.

Kolumn = Amount (Value column x-01-01: X-Kolumndatum)


Accumulated per year, whole year
The formula always calculates the accumulated value up to the last period of the year. The usual formula for cumulative values calculates the cumulative value up to the period reported.


Accumulated average per year
Used to calculate the mean value of all the values reported during the year. When you select the formula, the drop-down list appears:

  • Value column – Select the column from which to calculate the accumulated average.

Column = average (bleed column column Date: Bleed column year-01-01)


Deviation
Use to calculate how much values in a column deviate from values in another column. When you select the formula, two new rullgardinslistor are displayed:

  • Value column — Select the column that you want to see how much it differs from another column.
  • Target column -Here you select the column you want to see how much another column deviates from.

Columns = ((Value column * 100)/Target column)-100


Difference And Differential values available
Used to subtract values from two columns. When you select the formula, two new rullgardinslistor are displayed:

  • Value column – Select the column from which to subtract values.
  • Target column -selects the column whose values you want to deduct.

columns = Value column-Target column

Choose from Difference And Differential values available. Select Differential values available Uses a value of 0 if the bleed or target column does not have a value.


Previous value
Used to display the value that was reported in the previous period. When you select the formula, a new drop is displayed:

  • Value column -Selects the column in the measure to retrieve the previous value from.

Column = Bleed column (Previous period)


Previous year
Used to display the value reported in the same period last year. When you select the formula, the drop-down list appears:

  • Value column – Selects from which column in the measure the previous year's values will be retrieved.

Column = Bleed column (column date – 1 year)


Average interval
Used to calculate an average of the reported values in a range of measure columns.

  • Value column– Enter the first column whose value will be used to calculate the average
  • Target column– Enter the last column in the range

column = SUM (bleed column: Target column)/number of columns in the range


Identity
Used to retrieve a value from another column. The value that you retrieve is copied to the column where you set the identity formula. When you select the formula, the drop-down list appears:

  • Value column — selects the column whose values you want to retrieve.

columns = Value column


Target fullfilment %
Used to display the target achievement in the column, i.e. The outcome is relative to the target. When you select the formula, two new rullgardinslistor are displayed:

  • Value column – Select from which column in the measure the outcome value used to calculate goal fulfillment should be retrieved.
  • Target column -Select from which column in the measure the target value used to calculate goal achievement should be retrieved.

columns = (100 * Utfallskolumn)/Target column


Target Achievement% (forecast/outcome, target)
The formula is used if the Target fullfilment should be based on the forecast column throughout the year except at the last period when it should be based on the bleed column.

  • Value column -Selects which column the Target fullfilment will be based on during all periods except the last. "Forecast full year". If the measure contains a column that is named "outcome of the period," it will be used for the target fulfillment calculation in the last period.
  • Target column -Specifies which column the outcome or forecast should be divided by when the Target fullfilment is calculated.

columns = (100 * Value column or the column named "Outcome of the period" depending on the period)/target column.

Obs! If you do not see this calculation in the list, it needs to be activated by your consultant or by the support, click on the green question mark at the top right and then contacts.


Negative Target fullfilment%
Used if the color settings of the measure are set to "the smaller the better". In such cases, it is good to be under the target value (e.g. sick leave) and thus the target should have a target attainment above 100% when the outcome is lower than the target. When you select the formula, two new rullgardinslistor are displayed:

  • Value column – Select from which column in the measure the outcome value used to calculate the negative target fulfillment is to be retrieved.
  • Target column -Select from which column in the measure the target value used to calculate the negative target fulfillment is to be retrieved.

columns = (1-(Value column-Target column)/Target column) * 100


Negative target achievement% (forecast/outcome, target)
The formula is used if the negative Target fullfilment should be based on the forecast column throughout the year except at the last period when it should be based on the bleed column. 

  • Value column -Selects which column the Target fullfilment will be based on during all periods except the last. "Forecast full year". If the measure contains a column that is named "outcome of the period," it will be used for the target fulfillment calculation in the last period.
  • Target column -Specifies which column the outcome or forecast should be divided by when the Target fullfilment is calculated.

columns = (1-(Value column or the column named "Outcome of the period" depending on the period)-target column)/target column) * 100

Obs! If you do not see this calculation in the list, it needs to be activated by your consultant or by the support, click on the green question mark at the top right and then contacts.


Next year
Used to display values reported in the same period one year ahead. When you select the formula, the drop-down list appears:

  • Value column — selects from which column next year's values will be retrieved.

Column = (bleed column column date + 1 year)


Period And Period in
Used to get the outcome of the period if you have an accumulated outcome. Ex: March-Feb = period outcome for March provided that you enter accumulated values manually in the Bleed column.

  • Value column -Select the column you use to manually enter accumulated values.

Column = Bleed column (period)-bleed column (period-1)

Select to view the period's outcome for the measure period or for an entire year with Period Or Period in.


Poängfärg
Used to let the color of the measure generate a value (one point). The points that each color will generate can be defined in the system settings, contact Stratsys for further assistance. See Contacts. When you select the formula, the drop-down list appears:

  • Value column – It is important to select the column on which the color of the measure is based. To find out which column the color is based on, you can look at the FärginställningarOn Måttfliken Settings.

columns = Färgvärde


Rolling 12
Used to calculate a cumulative value for the last year (regardless of the selected periodicity) per year. When you select the formula, the drop-down list appears:

  • Value column – Select the column in the measure to retrieve the values from.

Column = average (bleed column column date: Bleed column column date – 1 year)


Rolling 12 average
Used to calculate an average of data one year back in time. If there is no data one year back in time, the average value is calculated from the values available. When you select the formula, the drop-down list appears:

  • Value column – Select from which column in the measure the rolling 12 average should be calculated.

Column = average (bleed column column date – 1 year: Bleed column column date)


Last entered value during the year
Used when you want an inscribed value to be valid for the year-out period or until a new value is entered. The formula retrieves the value from another column, (column x), and displays this value for the current year. The value collected is the last entered value during the year and is the same or earlier than the period on which it is set. For periods where column x has no value during the year, the value is set from the nearest previous period that has a value. When you select the formula, the drop-down list appears:

  • Last entered value during the year – Select from which column the value is to be retrieved, column X.

columns = Value column


Last period last year
Used to display the last value reported in the previous year. When you select the formula, the drop-down list appears:

  • Value column – Select the column in the measure to retrieve the values from.

columns = Value column Förraåret-12-31


Summa
Used to summarize values from two columns. When you select the formula, two new rullgardinslistor are displayed:

  • Value column – Select one column whose values you want to sum.
  • Target column -Here you select the second column whose values you want to sum.

columns = Value column + Target column


Total interval
Sums up all values from one column to another column. When you select the formula, two new rullgardinslistor are displayed:

  • Value column -Here you select the column that the summation should begin with.
  • Target column -Selects which column is the last to be in the total.

Kolumn = Amount (Value column: Target column)


Total available values
Prints a value if there is a value in one of the columns. When you select the formula, two new rullgardinslistor are displayed:

  • Value column -selects one column whose values you want to sum.
  • Target column -Here you select the second column whose values you want to sum.

columns = Value column + Target column


First value of the year
Used to display the first value reported during the year. When you select the formula, the drop-down list appears:

  • Value column – Selects from which column the first value of the year is to be retrieved.

columns = Value column Column year – 01-01