I have a single cell that has data the following data:
Weight <unit of measurement> @ speed <unit of measurement>
Example: "40000 lbs @ 65 mph" "18143 kg @ 105 km / h"
Expression example:
=Fields.weight + " " + IIf(uom = "metric", "kg", "lbs") + " @ " ......
I am trying to find a way to do number formatting to add the thousands separator. Is there a way to format one specific field in an expression? I am trying to keep most of the formatting to be as native as possible, instead of user functions, in case the culture changes from "," to ".", etc.