Here is my data:
And I’d like to query the system when I click on a button:
How many times can I find the sum 90 (right leg) in the sum 360 (left leg) on the left?
If the system finds only 1 time, then it adds the two sums.
Here I put 90 as an example because it won’t find 1x90 out of 360, it will always try to go up.
If the system finds 2 times only, then it will do 2x90 + 90 again.
Here I put 180 as an example because it won’t find 2x90 out of 360, it will always try to go to 3x90.
If the system finds 3 times only, then it will be 3x90 + 90 again.
On the other two conditions, we always add the sum of the lower leg to make a total.
Without forgetting that once the calculation is done, the system removes the points calculated on each leg.
On condition 3, the system removes 3x90 points on the left and 90 points on the right, there will remain 90 points on the left and 0 points on the right.
If possible to have a demonstration directly on the workflow, please.
I would especially like to know how to do this on Bubble.
Thanks in advance.