Write, Bureaucrats, Administrators
273
edits
Calculation field: Difference between revisions
no edit summary
No edit summary |
No edit summary |
||
| Line 89: | Line 89: | ||
Library Item contains field Price.<br /> | Library Item contains field Price.<br /> | ||
To calculate the cost of the order, let’s add calculable field Sum using the following formula: | To calculate the cost of the order, let’s add calculable field Sum using the following formula: | ||
<source lang="java">#{count} * #{item.price}</source> | <source lang="java">#{count} * #{item.price}</source><br /> | ||
If an order can make a reference to several different items, their total cost can be calculated: <source lang="java">#{item@sum.price}</source> | If an order can make a reference to several different items, their total cost can be calculated: <source lang="java">#{item@sum.price}</source> | ||
The most expensive item: <source lang="java">#{item@max.price}</source> | The most expensive item: <source lang="java">#{item@max.price}</source> | ||
The cheapest item: <source lang="java">#{item@min.price}</source> | The cheapest item: <source lang="java">#{item@min.price}</source> | ||
The average price for the item: <source lang="java">#{item@avg.price}</source> | The average price for the item: <source lang="java">#{item@avg.price}</source> | ||