5 Replies Latest reply on Apr 30, 2013 12:43 PM by GuyStevens

# Calculation using just one row of the portal - HELP!

### Title

Calculation using just one row of the portal - HELP!

### Post

I want to calculate the percentage ratio of the total labor cost with the first row of the Item portal.  The first row will always be organizational services, so I want to take that amount to get the percentage ratio from the labor cost.  Can anyone help?  I have attached a screen shot.  The first red total on the right is the labor cost, the one underneath is where I want to have the calculated ratio percent.

I am not a filemaker expert, obviously.  I am learning this as I go.  So basic steps, please.  Thank you.

• ###### 1. Re: Calculation using just one row of the portal - HELP!

You could isolate the "Organizational Services" amount by creating a calculation field in that portal that says something like:

If the Item = "Organizational Services" then show the total amount. (of Organizational Services) in this calculation field.

Then to be able to use this either make it global (I don't know if you can) or create a summary field that gives the total of this calculation so that every record in this relationship has the same value.

Then create a calculation that takes your "940" and divides it by your global field or summary field (4000) and multiplies that by 100.

And that should give you 24%.

I hope that's what you are looking for.

If you need any more help implementing this, let us know.

• ###### 2. Re: Calculation using just one row of the portal - HELP!

Thank you.  Right now what I did, the field where the 24% is, I have made the calculation working off the top line of the portal.  So it will use whatever amount is there.  Problem is, what if it isn't "Organizational Services".  It is working for me right now, giving me the percent.

But, I know the way you are telling me will always give me the ratio for Organizational Services, I am just at a loss on what to do.  You explained it, but I am not sure how to do it.  If I send you a screen shot of my layout, will that help?

• ###### 3. Re: Calculation using just one row of the portal - HELP!

screen shot

• ###### 4. Re: Calculation using just one row of the portal - HELP!

Hey Peter, if you want this to be more flexible you could always add a checkbox so you can check for yourself what value (or multiple values) need to be the 100% value.

Shouldn't be to hard to implement. I'll see if I can make you a little example file.

• ###### 5. Re: Calculation using just one row of the portal - HELP!

I was thinking something like this:

https://dl.dropboxusercontent.com/u/18099008/Demo_Files_FMP12/Percentage_Check.fmp12

Where you manually check the value (or values) that need to amount to your 10%.

I don't know where your labor cost comes from but in my file I just entered it manually.

I hope this is along the lines of what you where lookng for.