Formula in custom field in Looker

[dwftm]

I made a custom field with a simple X+Y formula. But the results of the addition (+) is not right. 

The X+Y results are in the 3rd column. The 4th column is the results from other formula I try, which is: SUM(X)+SUM(Y). 

But I don't want to use the SUM formula because it will give an auto aggregation result which I can't use to form another formula field.

[a_shah]

Hi @dwftm 

It seems your data has NULLS, as I have seen this behavior where, at row level, adding a number to NULL will give NULL and hence the overall aggregate value will be incorrect. If you still need row level formula then handle the NULL in data by converting them to 0 and then create the formula you want to.

~Ashish