creating a calculation field

[GWitley]

I have a subscriber database. I enter the number of subscriptions for each user. I want to have a calculation field that takes the number of subscriptions and multiples that times a dollar amount. When I try to do this:

 

"name of field with number of subscriptions" * $3.00

 

I get zero as the answer.

 

What am I missing?

[Techphan]

I have a subscriber database. I enter the number of subscriptions for each user. I want to have a calculation field that takes the number of subscriptions and multiples that times a dollar amount. When I try to do this:

 

"name of field with number of subscriptions" * $3.00

 

I get zero as the answer.

 

What am I missing?

 

1) Is your calculation set to give a numerical answer (not text, etc)?

2) It should look like this: Calculation= Table::NumberField*3 (take out the dollar sign)

[GWitley]

Thanks! Taking out the $ was the key.