Looker Table Calculation - IF statement

[adriana_clinci]

Hi all, 

I m trying to add a table calculation using the If statement. 

I have a column that displays the below

and I want to add an if statement that will show the following: 

IF "Actual" then "No calculations required" , if "EstimatedBasedOnGlobal" then "The global brand results", otherwise "The same market & same brand results"

How can I ass this as a table calculation? 

Thank you!

[alexander_torre]

Hi, 

You should be able to create a custom dimension in the top left of the tables option, and then for the if statement:

if($table.columnname$ = "Actual", "No Calcs. Req'd", "The global brand resulst")

This would work if you only have two outcomes for the column: Estimated Calculations Required.