Hi,
I have created the new logical column with
sum(column_name)/sum(count column name)
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
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'.
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 .
Solution:ifnull(new logical column,0) ......Then concatenate the value to string.
No comments:
Post a Comment
Do you want to comment