How should I go about this? I have a field that displays a popup menu 5%, 6%, 7%....10%. Then I have a calculation field that should calculate the % of a total amount. For example "121.1 - 5%".

I added in the calculation field:

"Total * "0.0" & popupmenue (5%)"

the result is wrong.

I did not show the % sign so I thought this might work but it does not. Also it seems like this is not the way to do a calc like that.

Any help please!

i have used this formula it is a general layout but you can change the numbers to work for you.

Case ( Field1 ≥ 200 ;Case (Field1 ≤ 1000 ; 17 ;

Field1 ≤ 3000 ; 9 ;Field1 ≤ 6000 ; 6 ))

James

Well normally you can just format a number field to be a percentage. However, if you absolutely need the '%' sign as part of the popup menu, then you can try something like this. It will also allow you to control the rates instead of hardcoding them into your value list.

pct_sign_popup.zip

or:

number * .01 * ( 100 - GetAsNumber ( popup ) )