Formatting a number in a text calculation field

[SteveGriff]

Hi people

I have two fields - Price (number) and quantity (number)

I have a calculation field that does this: -

quantity & " @

[CaelC]

You can use an IF-THEN calculation to determine if the price is greater than .99, then don't do anything but if it is less than 1, then have the response be "0".

I would usually make the calculation in a separate field and then embed that field in your calculation right between the pound sign and the price.

I think you could probably just embed the IF-THEN into the original calculation as well but I haven't tried that.

I hope this helps.

[Vaughan]

Why not change the field's Number format to display with 2 decimal places?

[danjacoby]

Create a calc field, called QtyText, that equals NumToText(Quantity). Then use a merge field:

<<QtyText>> @ <<Price>>

Then Format/Number on the merge field, using currency, 2 decimal places, with currency symbol "

[Fitch]

Right, something like this:

quantity & " @