Column Calculation
Perform statistical operations—such as sum, average, maximum, minimum, median, standard deviation, and standard error—on values from an origin column across records that reference the current record.
Specs
Version
0.1.0 (updated on 2025-08-07)
Developer
Labii Inc.
Type
Column
Support Configuration
Yes
Support Readonly view
Yes
Support Edit view
No
Support Form view
No
Support Default value
No
Support Import
No
Allow multiple
Yes
Overview
The Labii Column Calculation widget enables powerful real-time data aggregation by allowing users to perform statistical operations—such as sum, average, maximum, minimum, median, standard deviation, and standard error—on values from an origin column across records that reference the current record. This widget is especially useful for automating complex calculations like material consumption, total check-in/check-out counts, yield analysis, and other cumulative metrics. By eliminating the need for manual computation and ensuring up-to-date values, the Column Calculation widget streamlines data tracking and enhances analytical precision across workflows.
The Column Calculation widget eliminates the hassle of manually converting values between different units. By configuring the conversion factor within the widget's settings, it can seamlessly perform automatic unit conversions.

Use case
Use this widget to calculate the total checkin volume.
Use this widget to calculate the total invoice amount.
Use this widget to calculate the yield.
Configuration
To configure the widget, specify the data to be calculated and the desired calculation method.
Columns of current table
Column (Unit) - Choose the column for unit. If this column is left blank, no unit conversion will be performed.
Origin table settings
Table (Origin) - Select a table that stores the original data.
Column (Source) of the Origin table - Select the column in the origin table that is associated with the current record.
Column (Value) of the Origin table - Select the column in the origin table that is associated with the current record.
Column (Unit) of the Origin table - Choose the column in the origin table that records the unit of the value. If this column is left blank, no unit conversion will be performed.
Query - Further refine the displayed records by adding supplementary query criteria.
Calculation settings
Data aggregation - Select how to aggregate the data for the value. Options include sum, average, max, median, min, standard deviation, and standard error.
Conversions - Specify the conversion factors for every unit utilized, ensuring inclusion of all units within the quantity unit. If a unit is not provided, a factor of 1 will be utilized.
Stop condition - The formula will stop calculation when the condition is met. It must return a
true
orfalse
value. This field does not support other column data, you can only use the variabledata
to reference the current record data.Should auto update when readonly - If checked, this widget will perform a live calculation when readonly.
Example
Below is the widget configuration for performing calculations using data from the consumption table.
{
"current_unit": {
"sid": "xxx",
"name": "unit"
},
"origin_table": {
"sid": "xxx",
"name": "checkin"
},
"stop_condition": "data !== \"\"",
"data_aggregation": "se",
"origin_column_unit": {
"sid": "xxx",
"name": "unit"
},
"origin_column_value": {
"sid": "xxx",
"name": "quantity"
},
"origin_column_source": {
"sid": "xxx",
"name": "stock"
},
"should_auto_update_when_readonly": false
"conversions": [
{
"unit": "µL",
"factor": 1
},
{
"unit": "mL",
"factor": 1000
},
{
"unit": "L",
"factor": 1000000
},
{
"unit": "µg",
"factor": 1
},
{
"unit": "mg",
"factor": 1000
},
{
"unit": "g",
"factor": 1000000
},
{
"unit": "kg",
"factor": 1000000000
},
{
"unit": "Each (EA)",
"factor": 1
},
{
"unit": "Dozen (DZ)",
"factor": 1
},
{
"unit": "Gross (GR or GRO)",
"factor": 1
},
{
"unit": "Pair (PR)",
"factor": 1
},
{
"unit": "Case (CS or CA)",
"factor": 1
},
{
"unit": "Pack (PK)",
"factor": 1
},
{
"unit": "Bundle (BDL)",
"factor": 1
},
{
"unit": "Carton (CTN)",
"factor": 1
},
{
"unit": "Set (SET)",
"factor": 1
},
{
"unit": "Roll (RL)",
"factor": 1
}
]
}
Views
See the interface of the widget in the following views.
Readonly view
Readonly view display the values of the column.

In the readonly view, a warning message will be shown when the remaining volume is equal to or less than the specified threshold.
Edit view
The Edit view is the interface that allows you to modify the value.
Edit view is not supported for this widget.
Form view
The Form view is the field integrated into the add form for collecting values when creating a new record.
Form view is not supported for this widget.
Data
Each widget in Labii stores data in a unique manner; refer below to understand how data from this widget is stored.
Data format
Numeric values.
Default value
The Default Value field within the column allows you to specify the default value when a record is created.
Default value is not supported for this widget.
Import value
The Import Value is the value you need to include in your Excel table for it to be imported into Labii.
Import value is not supported for this widget.
Last updated