Announcements
I have 2 forms in powerapps that are related in a calculation matter. I want a field in form1 to calculate another group of fields from form2, but its not reading the following formula:
Text(Sum(A1+A2+A3+A4+A5+A6+A7+A8+A9+A10+A11+A12+A13+A14+A15+A16+A17+A18+A19)/95,"#0%")
Kindly support
@Anonymous ,
What are the references A1, A2 etc - are they fields, controls, variables or something else. I just tested
Text(Sum(1+2+3+4+5+6+7+8+9+10+11+12+13+14+15+16+17+18+19)/95,"#0%")
and received 2%
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
The references A1,A2..... are Text Inputs Generated from a form which contain numbers
Thanks,
If these are the Text control names, you need
Text( Sum( Value(A1.Text) + Value(A2.Text) + Value(A3.Text) + . . . . . . . )/95, "#0%" )
It's not working. I got an error again!
That does not help me see the problem - can you please supply the exact code (in Text) you are using and what the error is. The syntax is valid providing your references are.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 350 Super User 2026 Season 2
M Bilal Khan 318
Mohsin Ali 220
