sum function

J

jayadamson

I have a query with two linked databases. Database 1 has these fields:
RawMaterial, Ratio, CostPerGram. Database 2 has the field, BatchTotalGrams.
I created a datasheet form based on this query with these fields and one
calculated field, TotalCostRawMaterial. The formula for the calculated field
is Ratio/Sum(Ratio)*CostPerGram*BatchTotalGrams. This works perfectly. It
gives me the total cost for the ingredient based on it's ratio of the total
compared to all the other ingredients. Now I want to create another
calculated field in the footer of the datasheet form that sums the calculated
field. It won't work if I sum the calculated field or if I enter the formula
from scratch as follows: sum(Ratio/Sum(Ratio)*CostPerGram*BatchTotalGrams).
What do I do??
 
Top