SAC_Finding the X location of the lowest point in list

[Oleg.Konovalov.SIT]

Dear colleagues!

I have a following challenge:

I have six points (ap7,ap8,ap9,ap10,ap11,ap12). In my subassembly these six points can have different locations with anyone of them becoming the lowest. Using math.min formula I successfully find the lowest of them in my P25 point. 

Now, the question is, how can I find the X of this lowest point? I want my P25 to be in X and Y coordinates of the lowest point.

I'm pretty sure I could use Decision with multipple checks using OR, but that would cause me to make 6 decisions with 5 OR condition checks, which makes me sad 😞

I was wandering if there is some magic formula something like "find the X of the lowest point in list".

Will appreciate and advice.

With kind regards,

Oleg

[Oleg.Konovalov.SIT]

Dear colleagues!

I have a following challenge:

I have six points (ap7,ap8,ap9,ap10,ap11,ap12). In my subassembly these six points can have different locations with anyone of them becoming the lowest. Using math.min formula I successfully find the lowest of them in my P25 point. 

Now, the question is, how can I find the X of this lowest point? I want my P25 to be in X and Y coordinates of the lowest point.

I'm pretty sure I could use Decision with multipple checks using OR, but that would cause me to make 6 decisions with 5 OR condition checks, which makes me sad 😞

I was wandering if there is some magic formula something like "find the X of the lowest point in list".

Will appreciate and advice.

With kind regards,

Oleg

[KMercier_C3D · Accepted solution]

There may be a different way to do it but I was able to get it to work by using two Auxiliary Points. 

My first auxiliary point used your math.min formula to find the y coordinate.

Then my second auxiliary point referenced the first auxiliary point and compared each of the points y values to the test auxiliary point to find the correct x value. 

[KMercier_C3D · Accepted solution]

There may be a different way to do it but I was able to get it to work by using two Auxiliary Points. 

My first auxiliary point used your math.min formula to find the y coordinate.

Then my second auxiliary point referenced the first auxiliary point and compared each of the points y values to the test auxiliary point to find the correct x value. 

[ecfernandez · Accepted solution]

Hi @Oleg.Konovalov.SIT, I hope you're doing fine. The only thing that occurred to me so far is this:

1. Create a variable to find the Ymin, as you did it but within a formula (my example)

2. Create another formula to compare the Y coordinate of your known points with the result of your previous formula. In that way, when the Y value coincides, you'll have found out which point was the one with the lowest elevation, and therefore you'll be able to get its X value. (my example)

3. Create your new point (P25 in your case) and assign the two formula values to the X and Y coordinates. (my example)

Finally, you will have the point where you need it to be. As you can see in the following image, they are overlapped.

I hope this helps. Best regards!

[ecfernandez · Accepted solution]

Hi @Oleg.Konovalov.SIT, I hope you're doing fine. The only thing that occurred to me so far is this:

1. Create a variable to find the Ymin, as you did it but within a formula (my example)

2. Create another formula to compare the Y coordinate of your known points with the result of your previous formula. In that way, when the Y value coincides, you'll have found out which point was the one with the lowest elevation, and therefore you'll be able to get its X value. (my example)

3. Create your new point (P25 in your case) and assign the two formula values to the X and Y coordinates. (my example)

Finally, you will have the point where you need it to be. As you can see in the following image, they are overlapped.

I hope this helps. Best regards!

[fcernst]

You should mark this as Solved with Katie’s solution. She quickly finds the x value with one line of code for the X value without lining up multiple Decision graphics like you were worried about..

[fcernst]

You should mark this as Solved with Katie’s solution. She quickly finds the x value with one line of code for the X value without lining up multiple Decision graphics like you were worried about..

[ecfernandez]

Hi guys! 

@fcernst is right. Sometimes we post replies almost at the same time. Therefore, I hadn't even noticed that @KMercier_C3D had also posted a very good answer to @Oleg.Konovalov.SIT question. Let's wait for him to see the answer and accept the solution. My respect for @KMercier_C3D; she's the best (in my opinion) at working with SAC.

Best regards!

[ecfernandez]

Hi guys! 

@fcernst is right. Sometimes we post replies almost at the same time. Therefore, I hadn't even noticed that @KMercier_C3D had also posted a very good answer to @Oleg.Konovalov.SIT question. Let's wait for him to see the answer and accept the solution. My respect for @KMercier_C3D; she's the best (in my opinion) at working with SAC.

Best regards!

[Oleg.Konovalov.SIT]

Thank you very much, Kati, for your fast reply! It has worked perfectly. Later on it has brought me to another challenge when I have several lowest points and need to find which one is the most right, or the most left depending on general slope. But that it is another case and if I fail it on my one - will post example.

Again, thanks a lot!

[Oleg.Konovalov.SIT]

Thank you very much, Kati, for your fast reply! It has worked perfectly. Later on it has brought me to another challenge when I have several lowest points and need to find which one is the most right, or the most left depending on general slope. But that it is another case and if I fail it on my one - will post example.

Again, thanks a lot!

[Oleg.Konovalov.SIT]

totally agreed)

[Oleg.Konovalov.SIT]

totally agreed)

[Oleg.Konovalov.SIT]

Hi, Camilo! I'm positive that Variables would work too, but using "If" operator inside of Delta Y seems to be faster abd easier. Anyway, thank you very much for your solution!

[Oleg.Konovalov.SIT]

Hi, Camilo! I'm positive that Variables would work too, but using "If" operator inside of Delta Y seems to be faster abd easier. Anyway, thank you very much for your solution!

[ecfernandez]

Hi @Oleg.Konovalov.SIT. Yes, I agree 🙂

Happy to help anyway. Best regards!  

[ecfernandez]

Hi @Oleg.Konovalov.SIT. Yes, I agree 🙂

Happy to help anyway. Best regards!