cancel
Showing results for
Search instead for
Did you mean:
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
Continued Contributor

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.

1 REPLY 1
Continued Contributor

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.

## Helpful resources

Announcements

#### Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

#### Claim Your Badge & Digital Swag!

Check out how to claim yours today!

#### Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

#### Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

#### Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (51,960)