1 Reply Latest reply: Feb 27, 2013 9:53 AM by Srini VEERAVALLI RSS

    Issue with the divide by zero in the Repository

    prassu
      Hi,
      I have created the new logical column with
      sum(column_name)/sum(count column name)

      i enabled
      prevent_divide_by_zero=yes
      enable_db_hints=yes

      in the NQSconfig.INI

      When i create a column rpd handles with nullif(sum(count column name),0)
      it means again if the column value returns null then replace with '0'.

      In answers i have concate a string to the new logical column.....If the column returns null then it is only showing that string..

      But my concern is i want to show '0' if i dont get any result .

      thanks,
      prassu