Confluence has been updated to version 6.15.9

Table Grid Editor Documentation
Page tree
Skip to end of metadata
Go to start of metadata

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