OQL - Division and Multiplication Generating Error?
Hi – in my OQL statement, I have the following as an expression in my select statement: (sum(fieldA):sum(fieldB)) * 100 This generates a nullpointerexception, but when I remove the * 100, it works fine? Not sure why? The only difference is, I’m multiplying by 100?
Can you provide the whole statement? The expression validity may depend on the rest of the syntax
Is the actual value after you remove the * 100 ‘null’? Then perhaps it could be the case that you can't multiply a ‘null’ value. 0 you can.. Also, be aware that in your statement fieldB if zero, can generate an exception since you can't divide by 0.