AND OR precedence rule

[fmvizcaino]

Hi everyone,

I just realized the precedence rule for AND OR is totally wrong. Am I crazy??

Considering AND as a multiplier and OR as an adder (according to logic gates theory), the following should give me 4 rows as a result, without the need to add parenthesis.

Best,

Fernando Vizcaino

[FilipR]

In order not to go crazy with AND/OR conditions, always put them in parenthesis in a logical way. 😁

It's good practice for whatever language you're writing in. 

[fmvizcaino]

Hey @FilipR ,

I agree with you that it's a good practice, but that doesn't correct the issue.

It would be similar to having the following:

2+2x2 = 8

2+(2x2) = 6

As math principles are, logic gates principles should also be consistent here.

Best,

Fernando Vizcaino

[IraWatt]

🤣 I have never thought about it. But after checking I think your right @fmvizcaino ! 

Does the Formula Tool have a specific programming language or is it an Alteryx creation which is transpiled to a language?

[fmvizcaino]

I dare to say it's C-based. 🤔

https://help.alteryx.com/developer-help/build-custom-formula-functions

https://community.alteryx.com/t5/Engine-Works/Creating-an-Alteryx-Custom-Function-in-C/ba-p/366004

[IraWatt]

@fmvizcaino C based but what ever converts it to C ignores precedence. Seems this has been hiding in plain sight 😅 great spot. 

[atcodedog05]

This is defeinetely an interesting use case @fmvizcaino 😀