0 votes
1 view
in BI by (17.6k points)

I have two Measures in Tableau, “Initial Loan Rating” and “Final Loan Rating”. Each of these two measures will use one of four ratings in them (Pass, Minor, Moderate, Severe). All of the “Initial Loan Rating” measures will have at least one of the four ratings. However, the “Final Loan Rating” measure not always will have this field populated.

I’m trying to create a calculated field that will look at the “Final Loan Rating” measure, IF field is empty THEN populate what is shown in the “Initial Loan Rating” measure. ELSEIF “Final Loan Rating” has something populated THEN show what is populated.

I know how to do this in Excel with the following formula =IF(b2<>””,B2,A2) I’m just having difficulty translating this to Tableau language.

1 Answer

0 votes
by (15.6k points)

Try the calculation field

IF [Final Loan Rating] = "" THEN [Initial Loan Rating] ELSE [Final Loan Rating] END

 Are you new to Tableau and want to learn more about it, then join the Tableau Training program provided by Intellipaat.

Related questions

0 votes
1 answer
asked Jul 30, 2019 in BI by Ashok (47.2k points)
0 votes
1 answer
asked Dec 26, 2020 in SQL by Appu (6.1k points)
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...