Paste
Cut
Copy
AutoFill
You need a browser which full supports HTML5 Canvas to run SpreadJS
Whether to aggregate the values of the Calculated item value the total
Source Field Name:
Calculated Item Name:
Formula:
Priority:
- To add a Calculated Item enter Source Field Nameļ¼ CalcItemName and Formula and click the below button.
For Example
: Add
Product
to source field name, and
all pens
to calculated item name, and
=Product[Pen]+Product[Pencil]
to formula, to have a calculated item for 'all pens'. You can find the inserted item in the current field.
- To remove a Calculated Item, enter the name in the Source Field Name box and enter the name in the Calculated Item Name box click the below button.
For Example
: Add
OrderStatus
to source field name, and
Order Proportion
to calculated item name
- To update a Calculated Item, You can modify a Calculated Item by modifying the formula and priority
For Example
: Add
OrderStatus
to source field name, and
Order Proportion
to calculated item name, and
=OrderStatus['Total order']/OrderStatus['Outstanding orders']
to formula, and
2
to priority
- Click the List Calculated Items to see the list of all Calculated Items that have been created.
H