AnsweredAssumed Answered

Calculating two calculated fields in a portal

Question asked by ogodt on Feb 25, 2015
Latest reply on Feb 26, 2015 by philmodjunk

Title

Calculating two calculated fields in a portal

Post

I'm going nuts crying

i have been making this: http://filemakerhacks.com/2012/09/13/aggregates-in-filtered-portals/ and it's
working perfect, i have made it with 2 tables and have one with "total sales per year" per costumer and one with "total claim amout per year" per costumer.
now i want to have a field that shows the claim percent - per year/costumer and that would normally be:

("total claim amout per year" per costumer) / ("total sales per year" per costumer) * 100

But i have tried everything and googled for days witout any solution, i hope there is someone WHO can help.

\Ole

 

Outcomes