# How to? Create a "square" on a screen that can calculate and show a result? (w/ pics)

Hello!

How do I create a “square” with fields that can that input an amount on one side and show a result on the other. The same concept having 4 Excel cells (2 and the top and bottom) and having the left side input the right side show a total.

We need to from here:

Using this general look:

to get this:

It would be great if i could use the Table collection! lol

Thanks
Jamie

What is the calculation? Once you put the value into the left side, what do you want to happen to that number to get the right side?

Have you tried using a container? Or does it not show fields horizontally like you want?

Hi Marty!

At the top in yellow goes a number off at least 100.

Top left gets the first number (let’s say 40) they enter that and it’s subtracted from 100 appears in the top right (100-40) =60.

Bottom left, they pick a number less than the 40 (lets say 35) And it gets added to the \$60. 35+60=95

The remaining amount will go in the bottom right. (\$5)

Both sides will add up to the amount in the yellow box : 100

Ex: 100

40 | ( 100 - 40)=60
95 | (100 - 95) =5

I did try and yes with containers it’s just horizontal so far as the result.

Hi Jamie,

So I’ve had a look and this is what I’ve managed to come up with using 1 Number Entry and 2 Data Grids:

This is the only way I worked out that kind of matched the layout you wanted.

If you want to see the Colums I made for this let me know.

3 Likes

Where do they add the 35 thing based on your example? You’re showing 95 in your comment, not the entry to input 35.

Yes please send it! I appreciate the effort!!

You are correct, my apologies. Great catch!

In the bottom left corner is a combination of numbers that add up to 95 there.
The 35 they choose gets added to the \$60 (from side 1 top right).

The top rows added together will always come out to whatever number is box initially (row now \$100). The same for the bottom row when added together.

They’ll have (the users) alerts to let them know how high or low they can go though.

So There are 3 (User Specific) Number columns:

Atleast 100 - This is for the Number entry at the top.

Side 1 (Top Left) - This is for the top left value of the data grid

Side 2 (Bottom Left) - This is for the bottom left value of the data grid.

There are then 3 Math Colums:

First Calculation would be: Alteast 100 - Side 1 (Top Left)
You would have this as Side 2 (Top Right) in the data grid.

Second Calculation would be: First Calculation + Side 2 (Bottom Left)
This wouldnt need to be displayed anywhere based on your example, its just needed for the next calculation.

Third Calculation would be to get the remaining amount: Atleast 100 - Second Calculation.
This would be displayed bottom right in the data grid.

This is Data Grid 1:

This is Data Grid 2:

Hopefully that makes sense.

Based on this, if you’re wanting the 95 Displayed in the bottom left instead of the 35, you would need another number entry (Same as the Atleast 100 one) to input the 35… Then the bottom left of the 2nd data grid would be the Calculation of the 35 plus the Top right.

Makes perfect sense and I thank you for sharing.

TRULY I appreciate you helping me solve this issue!

Great insight!

Here’s the end result based on your suggestion:

1 Like