Compound Fields

When using Compound fields, is it possible to have the format of the source fields displayed in the resulting compound field? Example: currency fields have no comma and only one decimal point when displayed in a compound field.


Hi Paul,

Unfortunately you cannot control the formatting of the fields in compounds fields. I would advise using a text field with a default value (something like concat($field1,"-",$field2).
You may need to use the format() formula in the formula to get the right formatting for the currency field.

Thanks Jack. I’ll give that a try.

I get an error when trying to use that format function:

Error: Formula “format(“purchase_approval.total2”, $total_estimated_costs)” execution failed: java.lang.String cannot be cast to java.lang.Number

Disregard … I found my problem. This method will work nicely. Thanks again Jack.