Formatting parameter division

[fjjpeeters1976]

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

[fjjpeeters1976]

Solved it with dynamic formatting

[Deku · Accepted solution]

Dynamic formatting

See this video