Percent of a summary field

[Dick in Singapore]

I have a table of sales orders, and a summary field, Orders_sn for the Total of orders.

I'm producing a report that shows the number of orders for each weekday, for each month, followed by the month's total orders. (Two parts, one sorted by DayofWeek, one sorted by YearMonth.) All that is OK.

What I also want to is show the number of orders for each weekday as a percentage of the total orders for the month. (So as to see the distribution for each day of the week, for each month.)

I cannot figure out how to calculate Orders_sn (summarized by weekday) divided by Orders_sn (summarized by YearMonth), and display it in the part next to the Orders_sn by Weekday.

I would have thought that

GetSummary ( Orders_ sn;DayOfWeek) / GetSummary ( Orders_ sn;YearMonth) would do the trick, but not so.

I hope this makes sense, and would appreciate your advice.

[Søren Dyhr]

Check this:

http://www.filemakerpros.com/Percentages.zip

--sd

[comment]

Your calculation should work (provided it's in a sub-summary by DayOfWeek part, and the records are sorted correctly), so the problem is probably elsewhere.