CAPITAL Office Business Software

Hi, I have an odd one. On my invoices I was printing both ListPriceEx and the SoldFor fields - so that customers can see what the price difference is.
However, I recently removed the ListPriceEx field, leaving only the SoldFor field.

For some reason, the soldfor price only appears when there is a calculated value.

So I need to pick up the default list price if the soldfor field is empty.

I tried this as formula, but to no avail.

If IsEmpty("SoldFor")
Return Stock->ListPriceEx
Endif

The Test Function didn't show any syntax errors, but now all I get is *** on the first line in the SoldFor column.

Any suggestions would be greatly appreciated. Thanks

You're comparing the string "Soldfor" which is never going to be blank. Try:



instead.[/code]