+1 vote

From the above sample data, I need to calculate % complete for the order number 1.

Calculation for complete: (total number of points for status 'Delivered' / total number of points)*100

The result should be 57%

Can someone help me with the calculated field?

Jul 24, 2018 in Tableau 69 views

## 1 answer to this question.

SUM(IIF([Status]="Delivered",[Point],NULL)) / SUM([Point])

I assume that your column named Order No. extends all the way down each row (i.e., each row should have a 1 as Order No. but the screenshot does not show that.

Also, the above only works if the status of "Delivered" is consistently cased, which it is not in the screenshot. If it is not consistently cased, wrap [Status] in an Upper function:

SUM(IIF(UPPER([Status])="DELIVERED",[Point],NULL)) / SUM([Point])
• 10,250 points

## How can I calculate the median of sales price using 3 variables in Tableau

First let me clarify things for you. ...READ MORE

## How can I sort date field in presence of another date field in Tableau?

Goal: Sort the new ship date in ...READ MORE

## How to calculate the percent of records within a group in tableau?

You can click the measure SUM(Number of Records) and ...READ MORE

## Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...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