Jump to content

calculation


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

Recommended Posts

HI

I m trying to accomplish the following

Im using Filemaker pro 5, I've created a DB in order to keep up with all the jobs we have. Each job is allocated a job No. everything is working fine except I need a calculation to complete the DB. I have 5 feilds, each feild I need to give a seperate value eg.

Link to comment
Share on other sites

I can't quite work out what you are trying to do in the first part but the second question seems fairly straight foraward. You need four fields;

Time spent (number)

Activate (text with a pop up list Yes/No)

Hourly rate (global number assuming your rate is the same for all jobs)

Charge (calculation)

where the calculation is:

If ( Activate = "Yes", Time spent * Hourly Rate, "")

Hope that helps.

Link to comment
Share on other sites

This topic is 8525 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
×
×
  • Create New...

Important Information

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