Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
if [Legal Type 2]="Corp" and [Valid TIN]="Valid" and [Guarantor Subtype]="Unlimited" then "Priority 1"
else if [Legal Type 2]="Corp" and [Valid TIN]="Invalid" and [Guarantor Subtype]="Unlimited" then "Priority 2"
else if [Legal Type 2]="Indiv" or [Legal Type 2]="Trust" or [Guarantor Subtype]="Unlimited" then "Priority 3"
else if[Legal Type 2]="CORP" and [Valid TIN]="Valid" and [Guarantor Subtype]="Limited" then "Priority 4"
else if[Legal Type 2]="Corp" and [Guarantor Subtype]="Limited" and [Valid TIN]="Invalid" then "Priority 5"
else if[Legal Type 2]="Indiv" and [Guarantor Subtype]="limited" and [Valid TIN]="Invalid" then "Priority 6"
else if[Legal Type 2]="TRUST" and [Guarantor Subtype]="Limited" then "Priority 6" else ""
Thanks for replying to my post. I had two issues; case sensitivity and a typo on a field name ...
Regards
Hi,
What do the error messages say?
Click on the whitespace in a cell that has the green "Error" in it and screenshot/copy the error.
Pete
Proud to be a Datanaut!