jeudi 26 mai 2016

RSA Archer - Multiple IF statements

I'm hoping someone can help me

I have two fields with two different value lists; by choosing a value in Basel Business line 2 a value automatically populates Basel Business line 1.

I have created several IF statements, which validates correctly. However when testing this functionality. The First two IF statement work, so when I select "Advisory sales", Basel Business Line 1 automatically populates with "Corporate Finance" ie. However when I select "Card services" or any other values from If statement 3 or 4, no values is populated in Basel Business line 2.

IF((( OR( [Basel Business Line Level 2]=VALUEOF([Basel Business Line Level 2],"Corporate Finance"), [Basel Business Line Level 2]=VALUEOF([Basel Business Line Level 2],"Merchant Banking"), [Basel Business Line Level 2]=VALUEOF([Basel Business Line Level 2],"Advisory Services"), [Basel Business Line Level 2]=VALUEOF([Basel Business Line Level 2],"Municipal / Government Finance")), VALUEOF([Basel Business Line Level 1],"Corporate Finance")),

IF( OR( [Basel Business Line Level 2]=VALUEOF([Basel Business Line Level 2],"Sales"), [Basel Business Line Level 2]=VALUEOF([Basel Business Line Level 2],"Market Making"), [Basel Business Line Level 2]=VALUEOF([Basel Business Line Level 2],"Proprietary Positions"), [Basel Business Line Level 2]=VALUEOF([Basel Business Line Level 2],"Treasury")), VALUEOF([Basel Business Line Level 1],"Trading and Sales"))),

IF( OR( [Basel Business Line Level 2]=VALUEOF([Basel Business Line Level 2],"Retail Banking"), [Basel Business Line Level 2]=VALUEOF([Basel Business Line Level 2],"Private Banking"), [Basel Business Line Level 2]=VALUEOF([Basel Business Line Level 2],"Card Services")), VALUEOF([Basel Business Line Level 1],"Retail Banking")),

IF( [Basel Business Line Level 2]=VALUEOF([Basel Business Line Level 2],"Commercial Banking"), VALUEOF([Basel Business Line Level 1],"Commercial Banking")))

I can't figure out why the last two If statement aren't working.. Help please?

Aucun commentaire:

Enregistrer un commentaire