This how-to guide includes 3 task topics, all available without membership; use the index below to jump to the task you need and follow the entry path and steps.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Create a formula field and use SIN | Free |
| 2 | 2. Check the parameter format and enter the formula | Free |
| 3 | 3. Use a sample formula to verify the result | Free |
How-to Guide
1. Create a formula field and use SIN
Entry path: Add Field → Formula
- Open the multidimensional table that you want to edit.
- Click Add Field on the toolbar.
- Select Formula as the field type.
- Enter a formula that includes
SINin the formula editor. - Click Confirm to save and check the calculated result in the field.
Success Criteria
- Interface result: A new formula field appears in the table.
- Next action available: You can continue editing the formula or reviewing the result.
Tips While Using
- Common mistake: If you do not choose the Formula field type, you cannot enter a function formula.
- Environment note: You need permission to edit the current multidimensional table.
2. Check the parameter format and enter the formula
Entry path: Formula Editor → Function Library → SIN
- Open the function library in the formula editor.
- Select
SINto review its syntax. - Enter the formula in the
SIN(parameter)format. - Fill in a target value or a referenced field as needed.
- Save the formula and check whether a result is returned.
Success Criteria
- Interface result: The full
SINformula appears in the formula editor. - Next action available: After saving, you can see the calculated value in the record.
Tips While Using
- Common mistake: If the parameter format is incomplete or parentheses are not closed, the formula may not save.
- Environment note: The input should fit a numeric calculation scenario.
3. Use a sample formula to verify the result
Entry path: Formula Field → Enter a sample formula
- Create or select a formula field.
- Enter a sample formula such as
SIN(target range)or adjust it to your current field structure. - Save the formula and check whether the result appears immediately.
- Change the source data and confirm that the result updates with the data.
Success Criteria
- Interface result: The formula field shows the calculated result.
- Next action available: After data changes, the result can refresh accordingly.
Tips While Using
- Common mistake: If the referenced content is not a calculable numeric value, the result may be abnormal.
- Environment note: Sample formulas may need adjustment based on the actual field structure.