Equation - Round, Percent, Mid

[tianaranjo]

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?

[tianaranjo · Accepted solution]

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.