Struggling with formulas

[JHughes22]

Hi All,  I am really struggling trying to write the expressions for the formula tool.  Where can I learn how to write these, is it based on a specific programming language?  I need some type of guide to understand the functions and characters that are used in the expressions.  Any help would be appreciated.  Thanks, Jeff

[vizAlter]

Hi @JHughes22 - You should try the 

• Interactive Lessons

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons

especially, the "Writing Expression" section for your ask:

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20...

[JHughes22]

Hi vizAlter,  I have worked through all of these, but its like I am missing the background knowledge on them.  I dont understand what the characters are used for or when to use them, for example the !, / or ==, and what to put in each of the expression fields for example the c , or t.  Is this a specific programming language?  I think I need to go to that programming language 101 tutorial.

[vizAlter · Accepted solution]

@JHughes22 — Syntaxes are simple. Take a look at these links for more details:

https://help.alteryx.com/2019.3/Reference/Functions.htm

Operators (Important):

https://help.alteryx.com/current/designer/operators

Functions:

https://help.alteryx.com/current/designer/functions

[vizAlter]

@JHughes22 — If this post solves your issue please mark the answer "Solved" or "Solved" with a Like, if not let me know! This will help other users find the same answer/resolution.  Thank you.

(And, you can raise a new post anytime.)