This is only a suggestion. You can create an Inline table with all the mesuares that you want to transform your numeric values. Something like that:
Hundreds -> 100
Thousands -> 1000
Then you can create a list box with only showing the field Type_Mesure. In this way the user will be able to select how to see the data.
Then you need to modify your expressions with something like this:
Then depending on the selections the Numeric_value will be transformed. If any selections is done, the field will be showing with no transformation.
You could easily move the logic to the load script as variable function to maintain the function centrally.
Eg: Number format function
SET vSize = Div(Log10($1),3); SET vFormatNumber = Dual(Num($1/Pow(10,3*$(vSize($1))),'#,##0')&' '&Pick($(vSize($1)),'K','M','B','T'),$1);
In your sheets, you can call this variable: