TEXT(ThisItem.'MyColumnName', "[$-en-US]$#,##0.00")
Value(myColumn.Value)
Set(varMyAmount, Text(Value(Self.Value), "$#,##0.00));
Reset(Self);
varMyAmount

TEXT(ThisItem.'MyColumnName', "[$-en-US]$#,##0.00")
Value(myColumn.Value)
Set(varMyAmount, Text(Value(Self.Value), "$#,##0.00));
Reset(Self);
varMyAmount
Coalesce(
varMyAmount,
Text(
ThisItem.'MyColumnName',
"$#,###.00"
)
)
Value(
Substitute(
YourTextInput.Value,
"$",
""
)
)