Count of two columns output

[#1]

Hi All,

I required Output for the below columns as z= 1/6;

here is the table for the seven dates

	01-02-2015	02-02-2015	03-02-2015	04-02-2015	05-02-2015	06-02-2015	07-02-2015
x	0	0	1	null	0	0	0
Y	1	1	1	null	1	1	1

x- sum of x;

y- count of distinct date where content= null

so my output should be z=x/y as z=1/6;

Thanks in advance

Avinash

[swuehl]

How does your resident table in your data model looks like? I assume above is kind of a chart layout?

And you are looking for y: count of distinct dates where content is not equal null, right?

Is 'null' a text value or a NULL in the resident table?

And you want the output in a text box?

You can look into some functions that might help you here:

sum(), rangesum(), isnull(), nullcount()

[#3]

thanks for your reply.

Actually i want this output in table box for a field. I got it through using sum.