Hi,
Generally seeing all zeros on a calculated metric can mean one of two things:
- An issue with the syntax of the calculated metric formula
- One or more of the variables used do not contain data
The following are some common issues where calculated metrics return zeros:
- Multiplying by a decimal without a leading zero:
Incorrect:
[event2] * .5
Correct:
[event2] *0.5
- Multiplying by an event that is currently not implemented:
- Dividing by zero: Similar to multiplying by zero, except it shows as #DIV/0! instead.
- Open parenthesis: Forgetting to close parenthesis in your formula returns unexpected results or break the formula altogether:
Incorrect:
[event3] * ([event1] + [event2]
Correct:
[event3] * ([event1] + [event2])
- Using brackets outside variables:
Incorrect:
[event3] *[[event1] + [event2]]
Correct:
[event3] *([event1 + [event2])
- Accidentally removing a bracket:
Incorrect:
[event4 / 7
Correct:
[event4]/ 7
If after following all of the above troubleshooting steps your calculated metric is still not working as expected, have a supported user contact Customer Care.
Thanks,
Balaji