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.
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?
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.
I was thinking something like this:
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.