I’m using the Query builder on a panel, and I would like to simply select two fields and subtract them. When I fill out my query in the builder, and then switch to text edit mode, I can see it is putting a comma in after the minus sign. So this breaks the query.
I can easily edit the text, and make it work, but my issue is that I have weak SQL skills, and I need the builder to continue building out the query after the math operation. Am I doing something wrong? Or is this not working properly? And I tried building out the rest of the query, then going to the text to take out the comma, but it appears that switching between the text and builder doesn’t cause the query to get updated completely, in either direction.