cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Continued Contributor
Continued Contributor

Equation - Round, Percent, Mid

Greetings,

 

Problem:  Multiple 'labels' for one result

Desired Solution:  Consolidate into one label

 

Label 1  --> Text -->: 'Width (L2)'/ 1233 * 100 & "%" --> Result = ##.########, (ex:  63.77737226)

Label 2 --> Text --> Round(100% * ( 'html_Width (L2) in %'), 2) --> Result = 0.## (ex: 0.64)

Label 3 --> Text --> Mid('html_Width (L2) in %_3'.Text, 3, 2) &Mid('html_Width (L2) in %_3'.Text, 5,6) &"%" --> Result = ##% (ex: 64%)

 

Ultimately, I need the final result.  Any suggestions on consolidating from 3 (calculation) labels into 1?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Continued Contributor
Continued Contributor

Re: Equation - Round, Percent, Mid

I think I have it figured out:

Round(
((UserInput2 - UserInput1) * LineScale + varWidth) / VarLineWidth * 100, 0) & "%" 

I know it is hard to make sense of without understanding how the app is built.  This essentially is used to determine how to set the width of a table cell based on user inputs, overall width of a table, width of the first cell in a table.  

View solution in original post

1 REPLY 1
Highlighted
Continued Contributor
Continued Contributor

Re: Equation - Round, Percent, Mid

I think I have it figured out:

Round(
((UserInput2 - UserInput1) * LineScale + varWidth) / VarLineWidth * 100, 0) & "%" 

I know it is hard to make sense of without understanding how the app is built.  This essentially is used to determine how to set the width of a table cell based on user inputs, overall width of a table, width of the first cell in a table.  

View solution in original post

Helpful resources

Announcements
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,059)