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

    Dividing by zero resulting in a larger number

    Kaitlin Lockhart

      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.