
Re: Using Rounded Variables in Expressions
Jonathan Poole Sep 9, 2014 8:30 PM (in response to Katie Stancik)use the round() function with a divide by 1,000,000
replace
vA
vB
with
round( vA / 1000000 , .1) * 1000000
round( vB / 1000000 , .1) * 1000000
(I think for comparison purposes you actually don't need to multiple by 1000000 again. the 2nd parameter indicates i'm rounding to 1 decimal place. rounding is different than formatting to 1 decimal)
so....
='Total ' &
if( round( vA / 1000000 , .1) * 1000000 > round( vB / 1000000 , .1) * 1000000,
'is growing, increasing from '& round( vB / 1000000 , .1) * 1000000 & ' to ' & round( vA / 1000000 , .1) * 1000000,
if( round( vA / 1000000 , .1) * 1000000< round( vB / 1000000 , .1) * 1000000
,'is declining, shrinking from '& round( vB / 1000000 , .1) * 1000000 & ' to ' & round( vA / 1000000 , .1) * 1000000

Re: Using Rounded Variables in Expressions
Enrique Colomer Sep 9, 2014 11:56 PM (in response to Katie Stancik)I you have rounded the variables in your creation, the value of both are equal, ($8,1M). you can try putting in a text box and the value of another variable with 2 decimal format aver that result.
But if you have variable with their original value A is less than B
I suggest you keep the values of A and B and original rather than rounding formatees field when present, and in this case, use 2 decimals for the text consistent