cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
G99
Post Prodigy
Post Prodigy

Calculating sums from different screen

Hi All,

Not sure how possible this is, but on screen3 I have a dropdown, with choices 1-12, if a user selects 3 from the dropdown, i'd like the currency value found in DataCardValue10 on Screen 8 to be multiplied by 3 and the amount to appear in DataCardValue11, if 12 is chosen, then would need the value multiplied by 12, etc.

 

As the value in DataCardValue11 needs to use both the value in DataCardValue10 (they are both on the same screen), but also the dropdown in screen3 which is called "No.Required"

 

How possible is this please?

1 ACCEPTED SOLUTION

Accepted Solutions
eka24
Super User
Super User

With the help of a variable, you can achieve that. For intance:
 Set(varValue,Dropdown.Selected.Value) ---if user select 3, the variable will store the value 3

 

Then in the DataCardValue10  on whatever screen put in the default:
   varValue * 3

Or

   varValue^2

 

Repeat same process for the others.

 

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

2 REPLIES 2
eka24
Super User
Super User

With the help of a variable, you can achieve that. For intance:
 Set(varValue,Dropdown.Selected.Value) ---if user select 3, the variable will store the value 3

 

Then in the DataCardValue10  on whatever screen put in the default:
   varValue * 3

Or

   varValue^2

 

Repeat same process for the others.

 

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

G99
Post Prodigy
Post Prodigy

hi @eka24 

 

I'm not sure I follow entirely

 

creating the variable is ok, I've created on the OnHidden property of the screen that contains the dropdown

 

But on would on DataCardValue11 (Per item) - which is a currency field)) I need it to work out the total from DataCardValue10 currency field, and multiply it by whatever number is in the variable.

If I set the default of DatacardValue11 to:

varValue * 3 wont that just multiple the variable number, i.e. 2 items, by 3?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,230)