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