TO_INTEGER + TO_INTEGER generate a String not a Number
In a Query Table I put a formula like TO_INTEGER(IFNULL(MAX(xxx), 0)) + TO_INTEGER(IFNULL(MAX(yyy), 0)) AS "xxx + yyy". xxx and yyy are numeric columns with empty values.
And the problem is that that formula output value like "014" or "080" instead of 14 or 80.
Any idea ?