Can the order of operations be set to control how the data is generated when building calculated fields and functions?
There are multiple ways to handle this.
- Calculated Fields As a calculated field is created, parentheses can be added to dictate the order of operations.
- Calculated Fields Once a calculated field is defined, the behavior when aggregating can be set to (A). Calculate after rollup, (B). Calculate before roll up, then sum, or (C). Calculated before rollup then average
- Calculated Fields To define the order by which calculation execute, the execution sequence can be set on a Calculate fielded by clicking the vertical three dots.
- Data Pipelines Data pipelines can be set to calculate values based on referenced collections and/or the order of actions can be behind in the pipeline.