Selecting Null values

[Linda224]

I have this formula in a group selection:
{Command.chkiDueDate}=maximum({Command.chkiDueDate},({Command.cusname}))
to eliminate duplicates by selecting the greatest date

i also need it to eliminate duplicates by selecting the greatest value from another field that has nulls in it.

by putting

{Command.chkiDueDate}=maximum({Command.chkiDueDate},({Command.cusname}))

and

{Command.loanExposure}=maximum({Command.loanExposure},({Command.cusname}))


it works however it removes the records that have null for {Command.loanExposure}

??? Im lost ??? any suggestions

 

[synapsevampire]

Try setting File->Report Options->Convert nullvalue to default.

I'm lost in what you want, a null wouldn't be the largest value....

-k

 

[Linda224]

setting File->Report Options->Convert nullvalue to default did not change any thing


null wouldnt be the largest value but if it is null i dont want it do be removed.

I only want to remove the duplicates that are not null

 

[Linda224]

oh ooopps it did work i selected the wrong one

THANK YOU!!!