mardi 24 avril 2018

IF, THEN, ELSEIF Statement in Tableau

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.

Aucun commentaire:

Enregistrer un commentaire