Jump to content

Newbie request Help::: Calculated Field


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

Recommended Posts

yay.gif

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 smile.gif.

RonnieK yay.gif

Link to comment
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?

Link to comment
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. smile.gif

Link to comment
Share on other sites

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.