-
josephribaAsked on September 18, 2019 at 2:08 AM
Hi Victoria,
I have found a potential conflict in my logic but I am not sure how to resolve it.
Condition 117 is asked to show if there is more than one child and I am leaving
112 part of my estate or
113 all of my estate
to my children.
if 106 is > 1 and 112 = Yes then show 117.
if 106 is > 1 and 113 = Yes then show 117.
In my understanding this is a conflict as 117 is told to hide if 112 does not equal Yes but 117 is also told to show because 113 = Yes.
Is there a way to resolve this conflict?
Thank you
-
Nik_CReplied on September 18, 2019 at 4:51 AM
Well, that really depends on your requirements.
If that's the case, you should create conditions like this:
if 106 is > 1 and 112 = Yes and 113 = No then show 117.
if 106 is > 1 and 112 = No and 113 = Yes then show 117.
That should fix your conflict. And you can add another condition if both 112 and 113 are Yes (I'm not sure if there is such a possibility for you).
Hope it helps.
Thank you!
-
josephribaReplied on September 18, 2019 at 8:55 PM
Hi Nick,
There is a further problem with this. Please confirm that my solution is correct.
If 112 = yes then 113 will be hidden. So I cannot say if 113 = No
Is it still acceptable to say -
if 106 is > 1 and 112 = Yes and 113 = EMPTY then show 117.
if 106 is > 1 and 112 = No and 113 = Yes then show 117.
Also is it necessary to say anything about 113? Is the conflict resolved if I just say:
if 106 is > 1 and 112 = Yes then show 117.
if 106 is > 1 and 112 = No and 113 = Yes then show 117.
Thanks again for your help
Joe
-
AshtonPReplied on September 18, 2019 at 9:22 PM
Hello Joe,
Because 112 = yes then 113 will be hidden, which means you don't need to use 113 in your condition.
The correct conditions would be -
if 106 is > 1 and 112 = Yes then show 117.
if 106 is > 1 and 112 = No and 113 = Yes then show 117.
I hope this answers your question.
-
josephribaReplied on September 19, 2019 at 12:48 AM
Thanks Ashton. That is a great help.
I would also like to check this.
Is it acceptable to say:
If 53 < 2 then show 1E and 1R
If 53 > 1 then show 1E 1R 2E and 2R
If 53 > 2 then show 1E 1R 2E 2R 3E and 3R
Thanks again for your help
Joe
-
Nik_CReplied on September 19, 2019 at 3:31 AM
If 53 < 2 then show 1E and 1R
If 53 > 1 then show 1E 1R 2E and 2R
Well no, since If 53 < 2 condition will cover all.
You should combine:
If 53 > 1 AND If 53 < 2 show 1E and 1R 2E and 2R
So it will cover between 1 and 2 and show them all.