I am working on creating some calculated fields

The data for the "test2" field is imported from Access consists of numbers or "Null" in text.

I also have fields "test1" and "minimum" and "maximum" where all the three parameters are numbers.

I would like to create a calculated field with an if statement.

I would like to do the following:

1. If "test2" is not "Null" and "test2" < "minimum" then calculate "minimum" - "test2". (I was using the syntax IIF and != for not equal, but it did not like it because "Null" is a string value)
2. else if "test2" is not "Null" and "test1" < "minimum" then calculate "minimum" - "test1" Mar 27, 2018 in Tableau 117 views

## 1 answer to this question.

+1 vote

Below is the required code:

```IF (NOT ISNULL([test2])) AND [test2] < [minimum]
THEN [minimum] - [test2]
ELSEIF (NOT ISNULL([test2])) AND [test1] < [minimum]
THEN [minimum] - [test1]
END```

I guess ISNULL is the part where you got stuck. You can check out this link to learn more on ISNULL. answered Mar 27, 2018 by
• 10,240 points

selected Mar 27, 2018 by Atul
@Grim Thankyou for answering my query and giving additional useful resources for learning. This set of code worked for me.

## Creating a multiple charts with calculated field

Sample data: Table Name: A Mode Country Month Visitor ...READ MORE

## How to perform a calculation using one variable with an aggregation in calculated field?

Hi, You can use the calculative field and ...READ MORE

+1 vote

## How can I download tableau workbook with its data from tableau server?

In essence, no. Since the workbook is ...READ MORE

## How to calculate profit when cost and revenue are in same column?

You can create the following calculated fields: Profit: SUM(IIF([account_category] ...READ MORE

## Calculation issue: Distinct sum in Tableau

SUM( { FIXED [Brand], [Market]: AVG(Target) } ...READ MORE