Jump to content

Help:::: Stuck on Calculation Problem

This topic is 6437 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,

where Field A,B,etc equals regular numbers.

In one field I have a pop-up menu which gives me the option to choose the measurement unit used to calculate to Field B.

: each, inches and yards.

This is what I am trying to do::::::::::::::::::::::::::::::

FieldGTotal= Sum of all Fields

if i chose "PCS" the calculation for the "FieldGTotal"="field A"+""field B"*1 (Field B= countable product )

if i chose "Inches" the calculation for the "FieldGTotal"="fieldA"+"field B"/36 (Field B= measurerable product)(result given in Yards)

For Example

Field A! Field B! Unit Measured Field! Gtotal Field

500 !72 !inches ! 1000

100 !5 !PCS ! 115

Do I have to make a separate database to put inches values and etc? What is the best solution for this?

Please help.....

Share on other sites

Hi, ronnie! I'm not familiar with your terminology, but I think what you have would work using an IF statement or a CASE statement. I always find syntax a chore but it'd be something like...

FieldGTotal =

if (field B = "PCS", field A + field B, field A + (field B / 36))

or

case (field B = "PCS", field A + field B, field B = "Inches", field A + (field B/36), 0)

Anyway, the point is you can change the formula/equation depending upon the value of field B. Alternatively, you can create another field called "B converted" that would convert B to a base unit and then you could re-adjust the total to the appropriate unit from the field B selection.

I many not be understanding your question correctly, though... but I hope this helps.

--ST

Share on other sites

Dear Steve T.,

Sorry about my terminology. thanks for the help... I see the the solution now... thanks for the help... that script should do the job .

Share on other sites

This topic is 6437 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
• Similar Content

• Filemaker 6 for Mac issue.

By Tumma K,

• (and 4 more)

Tagged with:

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

By MrEddByrnes,

• (and 4 more)

Tagged with:

• 1 reply
• 4,149 views
• Moving data from fp5 to fp13

By bmill,

• (and 4 more)

Tagged with:

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

By randyinla,

• (and 4 more)

Tagged with:

• 1 reply
• 2,334 views
• Are there still hosting providers for filemaker 5.5?

By randyinla,

• (and 4 more)

Tagged with:

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

Important Information

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