Make a logical comparisons between a value and what you expect
Function:
Ifs(table = string, if_statement = {if = {col = string, logical_choice =string, value = string}, then = string}, else_value = string, new_col = string)
Parameters:
Table: Table name on which to perform function
Ifs Statement: Logical statement to evaluate, you can have as many of these as you need
- Column: Column to evaluate
- Logical Selection: How to evaluate the column (ie. Equals, Greater than, Is before date...)
- Value: Value to evaluate based on the logical selection (ie X = Y)
- Then: Value to return if the above condition is met
Else: Value if non of the conditions above are met
New Column Name: Name for the column
Examples:
Ifs(table = Budget, if_statement = {if = {col = "Geo", logical_choice = "Equals", value = "USA", if_group_logic = "And", col = "Segment", logical_choice = "Equals", value = "Mid Market"}, then = "USA MM"}, else_value = "Small Business", new_col = "Ifs statement")