Hi All

I want a negative number/currency field to display like this ($432.28), not $(432.28). I have written the following formula in the format editor dealing with negatives;

if{@lab cost variance}<0 then ("(""$"{@lab cost variance}")") else {@lab cost variance};

I 'check' the formula and am told that 'The ) is missing' in the 'then' part of the formula.

Please help

Thanks Dblank. Perfect.