Formatting parameter division

hi all,

I am creating a report where I give the user the option to see the result in a matrix in units, thousands and millions. When they use units or thousands I do not want to have a decimal but when they choose millions the result in the matrix should have 1 decimal. How would you advice me to do this, when using Format the result will be a text field right?

thanks,

Frank