2 Replies Latest reply on Sep 19, 2016 11:29 AM by Kaitlin Lockhart

# Dividing by zero resulting in a larger number

Hi, I'm running into a strange calculation issue, illustrated below. The left most column is spend and the middle column is activations. I'm trying to determine the cost per activation on the right by dividing spend by activations. The formula I'm using is this:

IIF(ISNULL(Sum([Activation Spend])/sum([Activations])), 0, SUM([Activation Spend])/SUM([Activations]))

In the highlighted row, this is resulting in really big number! The values of spend and activations are actuals, not calculations.

• ###### 1. Re: Dividing by zero resulting in a larger number

Bump up precision on that second column... I have a feeling it's not an exact zero but something like 0.211...

• ###### 2. Re: Dividing by zero resulting in a larger number

That's exactly what it was! This whole time I thought Tableau was displaying actuals, not rounded values. Thank you so much!

1 of 1 people found this helpful