### 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.

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.