Formula in custom field in Looker

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

Screenshot (549).jpg

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.

0 1 1,098
1 REPLY 1
Top Labels in this Space
Top Solution Authors