## Overview Perform four arithmetic operations on the "[Numeric Value Column](/en/manual/table-management-num)" of a "[Table](/en/manual/table)". The formula works when the screen is displayed and when records are added, changed, or deleted. ## Limitations 1. Functions cannot be used. To use functions, use "[Formula (Extended)](/en/manual/table-management-formula-extended)" or "[Server Script](/en/manual/table-management-server-script)". 1. Date calculations cannot be performed. To calculate dates, use "[Formula (Extended)](/en/manual/table-management-formula-extended)" or "[Server Script](/en/manual/table-management-server-script)". ## Prerequisites 1. "Site Administration Permission" is required to configure settings. ## Operation Procedure 1. Open the [formula] tab and click the "New" button. 1. Select "Default" for "Calculation Method". 1. Select the output column from the target. 1. Set the formula. Column name (numerical value), numerical value, arithmetic operation, and parentheses can be used in the formula. Also, insert a half-width space between each column. If half-width parentheses are used in the column title, the column name must be specified directly. For the NumA, enclose Num○ in half-width parentheses, like this: (NumA). 1. Click the "Add" button. 1. Click "Update" at the bottom of the screen. When the message ""(Title)" has been updated." appears at the bottom of the screen, the update is complete. ## Log Output of Formula 1. Open the [formula] tab and check "Output Log". 1. Click "Update" at the bottom of the screen. 1. Use the F12 key etc. to check that the following log is output after creation or updating in the browser's developer tools console. 【Formula】 　Target: Gross Profit (NumA) 　Formula: Sales (NumB) - Total Purchase (NumC) 【Column Value】 　Sales: 1,000,000 　Total Purchase: 500,000 【Log】 ``` formulaSet: {"Target":"NumA","Formula":{"OperatorType":0,"Children":[{"ColumnName":"NumB","OperatorType":0},{"ColumnName":"NumC","OperatorType":2}]},"Id":1} formulaSource: {"NumA":500000.0000,"NumB":1000000.0000,"NumC":500000.0000,"NumD":0.0000} formulaResult: {"NumA":500000} ``` ### About Log Content The contents output in the log are as follows. ・formulaSet: Calculation Formula Setting ・formulaSource: Value of the columns used in the calculation ・formulaResult: Calculation Result The contents output in "formulaSet" are as follows. ・Target: Target Column ・Formula: Calculation Formula ・Children: Calculation Content ・OperatorType: Operator (0: None, 1: Addition, 2: Subtraction, 3: Multiplication, 4: Division) ・ColumnName: Column ・Id: Calculation Formula ID ## Operation Image  Add numerical value columns "Unit Price", "Quantity", and "Subtotal".  Select "Subtotal" for "Target" and enter "Unit Price * Quantity" for "[Formula](/en/manual/table-management-formula)".  Let's enter "Unit Price" and "Quantity" in the editor screen and calculate it.  The calculation will be automatically performed and saved when you press the "Create" or "Update" button.  If you have performed calculations on records that have already been saved or changed the formula, press the "Sync" button to recalculate. --- If the column name uses half-width parentheses, such as "Consumption Tax (10%)", you must specify the column name directly. For NumA, enter the column name directly, such as "NumA". If you specify an column that uses half-width parentheses in the "Column Name", an error will occur.  In that case, specify the column name as shown below.  It will be replaced with the column name in the list.  ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/table">Table Function</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-num">Manage Table: Column: Numerical Value</a><span>10.02.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-formula">Manage Table: Formula</a><span>10.03.2024 up</span></li> <li><a href="/en/manual/table-management-formula-extended">Manage Table: Formula (Extended)</a><span>10.03.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-server-script">Table Management: Server Script</a><span>08.13.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />