2 Replies Latest reply: Oct 23, 2012 9:39 AM by 964995 RSS

    case statement issue

    964995
      100.0*(ifnull(x,1))/(case when ifnull(yago(x),1)=0 then 1.0 else yago end)
      if i apply the above case statement
      i am getting value like:
      101.2
      1,23,456
      98.2
      94.4
      2,34,976
      here these two values are wrong(1,23,456...,2,34,976)
      how i can make these values also correct

      prblm is if denominator is 1 then it displaying :numartor value*100

      bethamsetty