Skip to Content
0
Former Member
Nov 12, 2007 at 10:11 PM

IsNull

31 Views

Post Author: hd1

CA Forum: Formula

I am trying to include a null value in my report. I've searched this forum and and found a formula like this one

If IsNull({WebAddress.Value}) then "N/A" else {WebAddress.Value}

It doesn't work though. I still get the same results. I think my situation is a tad different though. I am trying to include results that are missing information obviously, however the entire WebAddress table is empty for certain entries. So I think that is where my problem lies. I thought this formula would work because it saying that if the Value field is null then disply "N/A" or the value of the field. I still get the same results, it's not including entries that have no webaddress listed. Has anyone had a situation similar? The last post I looked at this issue was resolved but I do not know why it is not working for me. Any feedback would be most appreciated. Thank you!