Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Calculation Formula


lansdowne
 Share

Recommended Posts

I am trying to learn FilemakerPro from scratch(Novice) and have managed to set up my tables and fields to update from excel files.

They all appear to be working o.k. However I have 4 fields that are calculation fields in excel that I want to delete and have Filemaker do the

calculations in the database.

 

The database is for horse racing so for example I need to calculate the effect in lbs over each distance to give a "pounds per length" figure for each distance depending on whether the horse is a 3yo or older. To save confusion in the explanation here is the formula(and column headings) in excel form.

What would be the equivalent in Filemaker. I haven't decided to have whole number calculations or calculations to 2 decimals.

Can anybody give me both Filemaker Calculation formulas so that I can have a crack at working out the other 3 myself. ANY HELP would be much appreciated

 

 

Excel formula =IF(G2486=3,(8.5/(H2486*660/1100)),(9/(H2486*660/1300)))

 

(Excel Column headings) G= Age H=Furs

[TABLE]

[TR]

[TD=class: xl64]DaveyH[/TD]

[/TR]

[/TABLE]

Link to comment
Share on other sites

If(Age=3; 8.5/(Furs*660/1100);9/(Furs*660/1100))

 

It is probably better to leave the calculation alone, and do the rounding in the display format:

 

In Layout mode: select the field, choose Format-->Number...-->Format as Decimal and enter the precision you want.

Link to comment
Share on other sites

Thanks for that doughemi, worked perfectly.

 

managed to get all of the calculations and they work o.k.

 

I wonder if you could advise me on my next problem......relationships. My wife keeps vanishing when the man next door is sunbathing in the garden....Just kidding!!

 

I have my tables all sorted, updating from Excel and they work fine. I've done my relationship graph but as much as I read up about them I stil don't really know if I have got it right or not.

my tables are as below:

 

[TABLE]

[TR]

[TD=class: xl63] FMRESULTS[/TD]

[TD=class: xl64][/TD]

[TD=class: xl63]FMRACES[/TD]

[TD=class: xl64, width: 19][/TD]

[TD=class: xl63, width: 110]FMCOURSE[/TD]

[TD=class: xl64, width: 19][/TD]

[TD=class: xl63, width: 110]FMHORSES[/TD]

[TD=class: xl64, width: 19][/TD]

[TD=class: xl63, width: 110]FMDECS[/TD]

[/TR]

[TR]

[TD=class: xl65]_fkfmcourseID[/TD]

[TD][/TD]

[TD=class: xl65]__pkfmracesID[/TD]

[TD][/TD]

[TD=class: xl65]__pkfmcourseID[/TD]

[TD][/TD]

[TD=class: xl65]__pkfmhorsesID[/TD]

[TD][/TD]

[TD=class: xl65]__pkfmdecsID[/TD]

[/TR]

[TR]

[TD=class: xl65]_fkfmhorsesID[/TD]

[TD][/TD]

[TD=class: xl66][/TD]

[TD][/TD]

[TD=class: xl66][/TD]

[TD][/TD]

[TD=class: xl66][/TD]

[TD][/TD]

[TD=class: xl66][/TD]

[/TR]

[TR]

[TD=class: xl65]_fkfmracesID[/TD]

[TD][/TD]

[TD=class: xl66][/TD]

[TD][/TD]

[TD=class: xl66][/TD]

[TD][/TD]

[TD=class: xl66][/TD]

[TD][/TD]

[TD=class: xl66][/TD]

[/TR]

[TR]

[TD=class: xl66][/TD]

[TD][/TD]

[TD=class: xl66][/TD]

[TD][/TD]

[TD=class: xl66][/TD]

[TD][/TD]

[TD=class: xl66][/TD]

[TD][/TD]

[TD=class: xl66][/TD]

[/TR]

[TR]

[TD=class: xl67]Course[/TD]

[TD][/TD]

[TD=class: xl66]Race_no[/TD]

[TD][/TD]

[TD=class: xl66]CourseID[/TD]

[TD][/TD]

[TD=class: xl66]horseID[/TD]

[TD][/TD]

[TD=class: xl66]race_id[/TD]

[/TR]

[TR]

[TD=class: xl67]Type[/TD]

[TD][/TD]

[TD=class: xl66]Course[/TD]

[TD][/TD]

[TD=class: xl66]Course[/TD]

[TD][/TD]

[TD=class: xl66]Horse[/TD]

[TD][/TD]

[TD=class: xl66]No.Drw[/TD]

[/TR]

[TR]

[TD=class: xl67]Rdate[/TD]

[TD][/TD]

[TD=class: xl66]Type[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD=class: xl66]Horse[/TD]

[/TR]

[TR]

[TD=class: xl67]Rtime[/TD]

[TD][/TD]

[TD=class: xl66]Rdate[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD=class: xl66]Wgt[/TD]

[/TR]

[TR]

[TD=class: xl67]Going[/TD]

[TD][/TD]

[TD=class: xl66]Rtime[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD=class: xl66]OHM[/TD]

[/TR]

[TR]

[TD=class: xl67]Age[/TD]

[TD][/TD]

[TD=class: xl66]Go[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: xl67]Furs[/TD]

[TD][/TD]

[TD=class: xl66]Age[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: xl67]Class[/TD]

[TD][/TD]

[TD=class: xl66]Furs[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: xl67]Ran[/TD]

[TD][/TD]

[TD=class: xl66]Class[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: xl67]Pos[/TD]

[TD][/TD]

[TD=class: xl66]GRD[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: xl67]Drw[/TD]

[TD][/TD]

[TD=class: xl66]WA[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: xl67]Btn[/TD]

[TD][/TD]

[TD=class: xl66]AA[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: xl67]TBtn[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: xl67]Horse[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: xl67]Wgt[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: xl67]OR[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: xl67]GRD[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: xl67]WA[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD=class: xl67]AA[/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[/TABLE]

 

As you can see in the results table it doesn't have a primary key, but has three foreign keys is that o.k.?

 

eventually I want to be able to pull the form from the results table for the horses racing on that particular day in the FMdecs

table, hopefully looping through each runner and then displaying all runs for each horse sorted in rating order if that is poss.

As filemaker won't let me copy and paste the relationship plan so I photographed it, hopefully it will be readable.

 

Unfortunately I can't copy into here so I have facebooked it here.

 

http://www.facebook.com/media/set/?set=a.10150917655603957.528792.632873956&type=1&l=5d18f6865c

 

 

I would be grateful for your opinion. If this is o.k. the it's on to learning and playing around with layouts.

 

many thanks once again

 

Davey H

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use