Formatting Numbers in a Formulas

[Niet32]

I have a field that I would like to concatenate two numbers. Both numbers are spend levels.

I have them looking like this $21000, how do I get the comma in ($21,000)?

Thanks for any help.

[Genx]

You can apply formatting to the field (right click on it, choose Number format, choose format as decimal, use notation, choose your currency symbol, under seperators, select to use a thousands seperator, and insert the comma.

[Niet32]

Genx: I didn't mention that this is a text field. The actual info looks like this:

$21000 / $21000

I could put both fields in seperated by a "/" but it doesn't look as clean.

[comment]

Why not? If you use merge fields, it should look exactly like a calculation would.

[IdealData]

I must confess I didn't realise that you could mix numbers and text in a merge field like this:

<>/<>

I had to specify the thousands separator and currency symbol for the merge field.

Where number1 and number2 are defined as number fields and the "/" separator I keyed manually. The trick here was to manually type the "/<>2" text as an extension to inserting a merge field (number1) on the layout.

[comment]

I think a convenient way to do this would be:

1. Select the type tool and click on the layout to create a new text object;

2. Select Insert > Merge Field... > number1;

3. Type "/";

4. Select Insert > Merge Field... > number2;

5. Click outside the text object;

6. Select Format > Number... and format the fields as currency.

Note:

1. Formatting applies to all number fields merged in the text object;

2. There's a keyboard shortcut to select Insert > Merge Field...

[Niet32]

Thanks guys that worked great. Another lesson learned.