Way to Check all records for a non-null value?

[smooveb]

I have a real need to replace x with y when y exists:

A 1 <null>
2 <null>
3 y
4 <null>

Total = x

Having difficulty figuring out a function or syntax I can use to say x=If(anything but null exists in column 3 from left) then <whatever exists in column 3 from left)

Any ideas? Hoping the question is clear enough.
Thanks!
Barrett

 

[Sridharan]

Barrett,

You want to change the Total or the column three values. What exactly is X??? Is it a summation of all nonnull values of column 3. Would help if you provide more info.

Sri

 

[smooveb]

Ok, here's a little more info guys:

In this case, A is a dose, while 1, 2, 3, 4 coordinate to slides. y is a number used in science called fisher's exact, which is not a number, but a string. That's the key, or else yes, could just use a summation. As it is, would think about using MAX or something like If MAX(column 3) <> &quot;#empty&quot; then <y> or something...

Any help greatly appreciated! Every time I receive any business objects training, sure doesn't get into the functions it has available for use

Barrett

 

[nnearing]

If all the values are returned in a single row, you can use the following values:

If not IsNull then y else x.