This macro allows run calculation using velocity in wiki tables
Macro Parameters
Parameter | Description | Possible values | Default value |
---|
formula | Formula to use for the calculation in velocity | $B*$C or $row.get(2)*$row.get(3) for rows or $b*$c or $col.get(2)*$col.get(3) for columns | multiplication of the 2 columns to the left of the current column |
format | Display format of the resulting calculation. This uses DecimalFormat from java | 0.00 Euros | 0.00 |
Test Calculation in rows
Desc | Days | Price | Total HT | Total TTC |
---|
Test | 3.5 | 600 | 2100.00 Euros | 2511.60 Euros |
Test Calculation in rows using $row
Desc | Days | Price | Total HT | Total TTC |
---|
Test | 3 | 600.50 | 1802 Euros | 2155 Euros |
Test Calculation in columns
Desc | Test |
---|
Days | 3.5 |
---|
Price | 600 |
|
---|
Total HT | 2100.00 Euros |
---|
Total TTC | 2511.60 Euros |
---|
Test Calculation in columns using $col
Desc | Test |
---|
Days | 3 |
---|
Price | 600.50 |
|
---|
Total HT | 1802 Euros |
---|
Total TTC | 2155 Euros |
---|