IF statement Logic to check two values
Posted: May 18th, 2017, 7:23 pm
Hey,
I am trying to have some logic which tries to check if the right value has been chosen in relation to another previous value.
From the attached documents you will see that there are a number of countries and each country may have 1 or more WPAs. What the logic in WPA_ID is trying to do is to check whether the WPA chosen is really matched with that particular country that was chosen earlier in the form. The logic is not working correctly, i am missing something kindly help.
I have attached my cspro docs and an excel sheet to help us understand it better.
I am trying to have some logic which tries to check if the right value has been chosen in relation to another previous value.
From the attached documents you will see that there are a number of countries and each country may have 1 or more WPAs. What the logic in WPA_ID is trying to do is to check whether the WPA chosen is really matched with that particular country that was chosen earlier in the form. The logic is not working correctly, i am missing something kindly help.
I have attached my cspro docs and an excel sheet to help us understand it better.