23 lines
1.1 KiB
Markdown
23 lines
1.1 KiB
Markdown
# Advanced Formulas (SAC 2025.23)
|
|
|
|
Purpose: scripted calculations in data actions; choose visual editor for simple flows or script editor for full control.
|
|
|
|
## Authoring modes
|
|
- **Visual**: guided blocks for scopes, loops, assignments (027-advanced-formulas-scripts.md, 028-advanced-formulas-visual.md).
|
|
- **Script**: free-form syntax; full reference in 029-advanced-formulas-script-reference.md.
|
|
|
|
## Common patterns
|
|
- RESULTLOOKUP for driver retrieval; MEMBERSET for scoped loops; FOREACH for dimension iteration; IF/ENDIF for branching; DATA() for writes.
|
|
- Time offsets: use OFFSET on Date; handle week/month/year granularity explicitly.
|
|
- Exception aggregation: avoid mixing calculated members in copy rules where not supported.
|
|
|
|
## Performance tips
|
|
- Narrow MEMBERSET scopes (time/version/org) before calculations.
|
|
- Use temporary variables; minimize writes inside loops.
|
|
- Prefer APPEND vs OVERWRITE intentionally; chunk large periods.
|
|
|
|
## Testing
|
|
- Validate on small slice; check job monitor for syntax/validation errors.
|
|
|
|
Sources: 027, 028, 029 advanced-formulas docs (SAC Help 2025.23).
|