Hi people

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

I have a calculation field that does this: -

quantity & " @

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.

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

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 "

Right, something like this:

quantity & " @