Hi,

I want to plot a pie chart by taking the count of NULL value also

Kindly provide me a solution

Navaneeth

Hi,

In oracle we use

Select count (nvl (,"unknown")) from TableName , To include Null Values in the count.

How do I achieve the same in WebFocus, I want to draw a pie chart based on the Count of a field and that field might contain null value,

I want to show the count of Null in my Pie Chart

Regards
Navaneeth

What is the problem?
As long as MISSING = ON for the field in question you should be able to get the count

This message has been edited. Last edited by: venu,