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

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?

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.

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

JT Hughes

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