1 Reply Latest reply on May 23, 2016 12:24 PM by Tom W

# COUNTIFS

I have two sheets in a single Excel. I am trying to replicate an excel report in Tableau.

I have a formula that is used in Excel and when I am trying to change it and use it in Tableau I am facing difficulties.

I have 2 sheets in my excel data source:

Excel Formula:

=IF(AND(LEFT([AS Req],3)="Yes",[Seq]>=3,

COUNTIFS(tAlign[PID],[@[PNum]],tAlign[AlTree],"P and S",tAlign[L2],"IT")=0)

,1,0)

Calculated field in Tableau:

iif

(IIF (isnull([AS Req]),"No", left([AS Req],3)) = "Yes" AND [Seq] >= 3 AND

(IIF ([PID] = [PNum] AND [AlTree] = "P and S" AND [Level 2] = "ITAS" ,0 , 1)  = 0)

,1,0)

Since there are multiple records in the Align sheet, my IIF statement is returning values other than 1's and 0's.

I am new to tableau and unable to get this done. Can someone help me out here..

• ###### 1. Re: COUNTIFS

Hi Akshay,

Welcome to the forums. Please review the getting started information for the forum - Tableau Forum Guidelines

As outlined, it's recommended you post a Tableau Packaged Workbook to support your scenario outlined. It doesn't have to be real data, you can prepare some sample data in Excel to mock up the situation if required.