## Solution

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: If you want to multiply an event by one-half, use a leading zero.

Incorrect:
`[event2] * .5`
Correct:
`[event2] *0.5`

• Multiplying by an event that is currently not implemented: If a variable is involved in a multiplication formula that does not contain data, the result is always zero. Any number multiplied by zero is always zero.
• 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: Brackets are reserved for variable values. Using them as parenthesis does not return data:

Incorrect:
`[event3] *[[event1] + [event2]]`
Correct:
`[event3] *([event1 + [event2])`

• Accidentally removing a bracket: A variable can only be recognized with both brackets. Removing one does not return data:

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. Les publications Twitter™ et Facebook ne sont pas couvertes par les dispositions Creative Commons.