Formating problem

[bravo6]

When false, the fomula in my report returns the expected (and desired)amount in currency format (eg $1000.00). When true, it returns the correct amount and the leading "*" but not in currency format (eg * 1000) I need that "*" to appear before the number when the statement is true but I'm sure that the "*" is what is causing the the currency format to fail. Is there a way to fix this?

thanks.

=IIf((([sumofcount])>0) And (Right([Agent Name],2)="TL"),("* " & (([periodcomp])/((([sumofcount]))*1.2))),(([periodcomp])/(([sumofcount]))))

 

[Remou]

How about:

[tt]=IIf((([sumofcount])>0) And (Right([Agent Name],2)="TL"), (Format(([periodcomp]) / ((([sumofcount])) * 1.2), """*""$#,##0.00")), (([periodcomp]) / (([sumofcount]))))[/tt]