# Newbie request Help::: Calculated Field

This topic is 6435 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

I have a fields with a sum of different values (e.g: FieldGTotal=field A+field B+Field C+etc...), where Field A,B,C,etc are regular numbers. In one field I have a pop-up menu which gives me the option to choose the percentage(ex: 10%; 15%, 20%). What I am trying to do is to add the percentage chosen from the Pop-up menu to the total of the "Field GTotal". I tried using some of the scripts (couldn't figure it out); I also tried to use the value list (sum of Fields A;B;C... + %Field)- but it didn't work either. Any suggestions?

Any suggestions and help would be greatly appreciated .

RonnieK

##### Share on other sites

Sum( fieldA, fieldB, fieldC ) + percentage * Sum( fieldA, fieldB, fieldC )

or

Sum( fieldA, fieldB, fieldC ) + 0.01 * percentage * Sum( fieldA, fieldB, fieldC )

if percentage isn't a decimal.

Is this what you're trying to do?

##### Share on other sites

Field GTotal =Sum(fieldA,fieldB,fieldC)+Field Percentage(Pop-up menu chosen:10%,15% or 20%) this is what I am trying to do. for example if the total was 100, and I chose 10% from my pop-up menu, i would expect the GTotal to show 110; or if I chose 15%, I would expect the GTotal to show 115.

##### Share on other sites

The second one should work then, unless you have an actual percentage sign in the menu. You might need to use TextToNum( percentage ) then.

##### Share on other sites

JT Hughes

THANK YOU SO MUCH!!!!! IT WORKS.... Perfectly.....THANK You.....

##### Share on other sites

This topic is 6435 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account

• ### Similar Content

• #### Filemaker 6 for Mac issue.

By Tumma K,

• (and 4 more)

Tagged with:

• 8 replies
• 3,400 views
• #### FM3 upgrade to FM Pro 5.5 - Windows 8 installation possible?

By MrEddByrnes,

• (and 4 more)

Tagged with:

• 4,144 views
• #### Moving data from fp5 to fp13

By bmill,

• (and 4 more)

Tagged with:

• 2 replies
• 2,735 views
• #### Filemaker 5.5 database will not delete records on-line

By randyinla,

• (and 4 more)

Tagged with:

• 2,331 views
• #### Are there still hosting providers for filemaker 5.5?

By randyinla,

• (and 4 more)

Tagged with:

• 2 replies
• 2,283 views
×
×
• Create New...