5 Replies Latest reply: Sep 2, 2013 3:46 AM by Thomas Jensen RSS

    Show trend when second value is zero

      Hello,

       

      This is a newbish questions,

       

      But if i wanna show a trend based on two values i divied them,

       

      So eg i have:

       

      sum(amount) / sum(amount2)

       

      Lets say

       

      Sum(amount) = 1 and sum(amount2) = 0

       

      Then i want a trend which says its 100% , but as everybody knows, you cannot divied by zero.

       

      What can i do?