What's the order of mathematical operations in custom columns and why can't I use brackets to separate them? Feel like that's an important thing to have in Metabase. I know I can do it easily with SQL but was just wondering why it's not a feature or just to see if I'm missing something
Not sure i understand the question "What's the order of mathematical operations in custom columns" ... Can you let us know what exactly you're trying to do please
I mean if I create a custom column with a complex-ish equation sometimes the output is wrong but when I tried separating the steps into multiple custom columns thus simplifying my equation the output came out right so I was wondering how Metabase deals with equations, like in what order does it solve the equation, I assume that was what my output wrong. I also was interested in why it wasn't possible to use brackets in custom columns as it would kinda make the situation much easier
Can you please give any specific example of the expression that gives you wrong output?