Calc Macro
Редактировал(а) Coluns 19.11.2023
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 |