Introduction

If you want to calculate the content of a cell based on the values in other columns, you can use a formula.
For instance, if your grid is used to calculate line totals.

The total in the most right column is calculated as

^{{unit} * {price} * (100 - {discount}) / 100}

Configuration

Setup a custom field grid with following configuration

gd.columns = unit, price, discount, total
gd.tablename=formularesult
gd.ds = jira
 
 
col.unit = Number of units
col.unit.type = integer

col.price = Price
col.price.type = number
 
# 
# Discount can be any integer between 0 and 50
#
 
col.discount = Discount
col.discount.type = integer
col.discount.minValue = 0
col.discount.maxValue = 50
 
#
# The total will contain the calculated value
# 
 
col.total = total
col.total.type = number
col.total.formula = {unit} * {price} * (100 - {discount}) / 100

Related information

Page:

Formula - Examples
Page:

Using list values in formulas
Page:

Formula - formal syntax specifications
Page:

Formulas
Page:

Formula result if the column has a null value???

Table Grid Editor (legacy) Documentation

Formulas

Analytics

Introduction

Configuration

Related information

Related content