Confluence has been updated to version 6.15.9

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

 


Configuration

Setup a custom field grid with following configuration 


Code Block
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

Content by Label
showLabelsfalse
spacesTGPD
showSpacefalse
cqllabel = "formula" and space = "TGPDTGED"
labelsformula

...