From The Document Foundation Wiki
Jump to navigation Jump to search

will give the result Null' if one of the fields hasn't been entered. The solution is to use a function that tests whether fields contain data or not. Amongst the functions available IFNULL' is often used. Its syntax is