To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115165
------- Additional comments from o...@openoffice.org Thu Oct 21 10:50:56 +0000 2010 ------- I found a work around which you could use. You have to replace the casewhen() function call by the SQL syntax or case when like SELECT MONTH( "DATE" ) AS "Month", AVG( CASE when "MEAL" = '1' then "BG" else NULL end) AS "Breakfast", AVG( CASE when "MEAL" = '2' then "BG" else NULL end ) AS "Lunch", AVG( CASE WHEN "MEAL" = '3' then "BG" else NULL end ) AS "Dinner", AVG( CASE WHEN "MEAL" = '4' then "BG" else NULL end ) AS "Bed", AVG( "BG" * 1.0 ) AS "Daily Average" FROM "BG" WHERE YEAR( "DATE" ) = :Enter_Year_Desired_as_YYYY GROUP BY MONTH( "DATE" ) But it is still an issue to allow NULL as function parameter. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org
