Question

OQL - Division and Multiplication Generating Error?

0

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?

asked 2020-01-22

SL

2 answers

João Guedes · Answer 1 · 2020-01-28

Hi SL,

Can you provide the whole statement? The expression validity may depend on the rest of the syntax

Ivo Sturm · Answer 2 · 2020-01-28

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.