This discussion is archived
1 Reply Latest reply: Feb 27, 2013 7:53 AM by Srini VEERAVALLI RSS

Issue with the divide by zero in the Repository

prassu Pro
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points