Hello all! I have a question about rounded variables...
I've created 2 variables, Variable A and Variable B, and in the expression I've rounded the number to 1 decimal place ($8.1M, for example).
I then created a text box that will display different text based on whether Variable A is >, <, or = Variable B.
The catch is that I want to determine whether ROUNDED Variable A is >, <, or = ROUNDED Variable B, because very likely, Variable A will never be exactly equal to Variable B.
Variable A = $8,059,000
Rounded Variable A = $8.1M
Variable B = $8,112,000
Rounded Variable B = $8.1M
Technically, in this example, Variable A < Variable B, however, in the text box I want them to be shown as equal because of the rounding factor. Does anyone know how to create a formula that takes into account the rounded numbers?
My actual equation is here:
='Total ' &
'is growing, increasing from '& vB & ' to ' & vA,
,'is declining, shrinking from '& vB & ' to ' & vA