NULL value

[Matt Malyschko]

How do I determine if a calculation produces a null result. Eg: I have a calculation max(field1). If no data has been entered in field1 this should return null. How do I test for this? I tried using null and ""; neither worked.

Cheers.

[comment]

I am not sure I understand the context of your question. You can see if any field - calculation or not - is empty by looking at =

ression returns empty, e.g. =

IsEmpty ( Somefield )

Or you can test if an exp

IsEmpty ( Max ( Field 1 ) )

[Matt Malyschko]

isempty works as i was looking for. thanks.