Suppressing $ signs in details

[BillPeck]

I have detail records then a summary and want the $ sign to show up only on the first detail per group.

I tried to do this by having a conditional formula in Format Editor, Number, Customize, Currency Symbol for the "Enable Currency Symbol".

I figured this was a boolean field, so I tried to set up a conditional formula of "[line_count]=1". The error I got was "The formula result must be a number".

What should my formula look like?

Thanks.

Bill

 

[vidru]

It's expecting one of the "Currency Symbol Contstants"

crFixedCurrencySymbol = 0
crNoCurrencySymbol = 1
crFloatingCurrencySymbol = 2

-dave

 

[bdreed35]

Try something like this in Format Editor, Number, Customize, Currency Symbol for the "Enable Currency Symbol":

if {table.groupfield} <> previous({table.groupfield}) then
crFixedCurrencySymbol
else
crNoCurrencySymbol

~Brian

 

[BurnsORegan]

try a simple formula:

iif([line_count]=1,"$" & CurrentFieldValue, CurrentFieldValue)

or some such thought....

BurnsORegan

 

[bdreed35]

BurnsORegan:

Your formula will work but it the ouput will be a string rather than a currency field. This will affect your ability to perform summary functions on it.

~Brian