cancel
Showing results for
Did you mean:
Highlighted
Level: Powered On

## calculated field

Hi

I am trying to calcalate the value of several textinput boxes which are contained within a gallery that is on another screen to where I want the figure to show.  I have been trying to get a formula to work for days but to no avail.  I shall be most grateful if anyone can provide any assistance as at the moment, I can only get the most recent entry to pull through onto my screen, not all of the textinput values.

Thanking you in advance.

Lindsay

1 ACCEPTED SOLUTION

Accepted Solutions
Level 10

## Re: calculated field

Hello,

You can try this..
TextInput1_4.Default =  Sum(Gallery1.AllItems,TextInput2_1.Text)

6 REPLIES 6
Level 10

## Re: calculated field

Hello,

Are you trying to have something like this?
1    2  -->  3
2    5  -->  7
Or something like this?
1    2
2___5
3     7
If you provide some more information we can make it work

Community Support Team

## Re: calculated field

Could you please share a bit more about your scenario?

How do you calculate the value of several TextInput boxes? Could you please share a bit more about the formula?

If you want to display the calculated result within another screen, I think the Global variable could achieve your needs. You could consider take a try to store the calculated result into a global variable (using Set() function), then display the variable value within your another screen.

Please take a try with the following formula:

```Set(Variable1, CalculatedResult1);
Set(Variable2, CalculatedResult2);...```

then you could display the calculated result via the Variable1, Variable2, ... within your another screen.

More details about the Set function, please check the following article:

Set function

Note: You could not use UpdateContext() function to initialize your variable, context variables are scoped to a screen, which means that you can't build a formula that refers to a context variable on another screen.

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User

## Re: calculated field

I think that @Mike8 raises an excellent question, and the answer to that would be of great help to us.
What Mike is asking is - do you want to calculate a value from textinput boxes within a *single* record? Or do you want to perform some sort of an aggregate calculation? (in other words, do you want to calculate a value from *multiple*  records in your gallery?)

Level: Powered On

## Re: calculated field

Hi

Thank you both for your prompt replies.

I have attached screenshots to hopefully help clarify what I am trying to achieve.

Many thanks

Lindsay

Level 10

## Re: calculated field

Hello,

You can try this..
TextInput1_4.Default =  Sum(Gallery1.AllItems,TextInput2_1.Text)

Level: Powered On

## Re: calculated field

Hi Mike8

The Sum formula worked!

Thank you very much for your assistance.

Kind regards

Lindsay

Announcements

#### Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

#### Power Platform World Tour

Coming to a city near you

#### PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

#### Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 78 members 3,728 guests
Recent signins: