How to get value greater then NULL from a NULL field? 1

[Ladyazh]

My Param is {?Value}
Field is {t.value} and it is NULL.

task is to put a filter on a field and get all values greater then a filter - how do I do that?

If Not IsNull {t.value} then {t.value}={?Value}

doesn't work. Thanks

 

[synapsevampire]

Try:

If Not(IsNull({t.value})) then
{t.value}
else
0

Ifyou want to limit rows returned to the report to those greater than null, use Report->Selection Formula->Record:

Not(IsNull({t.value}))

If you want to limit them by a parameter, use:

{t.value} > {?Value}

-k

 

[Ladyazh]

Thanks I shall try that!

 

[Ladyazh]

If Not(IsNull({t.value})) then
{t.value}
else
0

gives an error asking for a boolean and it doesn't have a parameter in it. I need to enter parameter and get everything greater then parameter BUT field is NULL at this moment.

{t.value} > {?Value} is cool but if field is NULL?
If {?Value} entered is 1 - what will it bting if all rows of the {t.value} are NULL? I shall try...

 

[lbass]

For a record selection formula that excludes nulls and has the field > than a parameter value, you should be able to just use:

{table.field} > {?Value}

If you want to include nulls and values that meet the criterion, use:

isnull({table.field}) or
{table.field} > {?Value}

-LB