Calculating two calculated fields in a portal
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.