cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
enmanbj
Level: Powered On

Do Math Inside PowerApps

Hello, 

I want to add three fields on a screen in a totals box somewhere below these quantities boxes. I'm not even sure where to begin. Any thoughts?

 

Inkedmake totals box_LI.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
mdevaney
Level 8

Re: Do Math Inside PowerApps

@enmanbj 

Doing math in PowerApps can be done similar to very basic Excel.

 

For example: if you put this formula into the Text property of a new label (...and changed the DataCard references to the names in your app)

 

Value(DataCard_DispositionQty.Text)
+ Value(DataCard_Disposition-2Qty.Text)
+ Value(DataCard_Disposition-3Qty.Text)

 

The result would be:

 

3

 

If you are wondering, why was each DataCard_DispositionQty.Text enclosed within a VALUE function:  VALUE converts a text data type to a number.  You can only perform math on a number data type.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

1 REPLY 1
Highlighted
mdevaney
Level 8

Re: Do Math Inside PowerApps

@enmanbj 

Doing math in PowerApps can be done similar to very basic Excel.

 

For example: if you put this formula into the Text property of a new label (...and changed the DataCard references to the names in your app)

 

Value(DataCard_DispositionQty.Text)
+ Value(DataCard_Disposition-2Qty.Text)
+ Value(DataCard_Disposition-3Qty.Text)

 

The result would be:

 

3

 

If you are wondering, why was each DataCard_DispositionQty.Text enclosed within a VALUE function:  VALUE converts a text data type to a number.  You can only perform math on a number data type.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 436 members 6,174 guests
Please welcome our newest community members: