Formula collision occurs when a query has two structures and both structures contain formulas. The collision occurs at the point where the formulas intersect.
Eliminate Formula Collision
Always check if the default behavior delivers the desired result. If it does not then the following options are available in the Formula Collision Resolution field on the General tab of the properties of a formula (calculated key figure at query level):
- Use Result of This Formula
The result of this formula has priority in a collision.
- Use Result of Concurrent Formula
The result of a competing formula has priority in a collision.
If two colliding formulas are set to the same setting, the last specification made has priority.
On the Priorities tab, you also can view and modify the priority handling by explicitly specifying which property is actually taken into account.