Is there anyway to do a sum of averages within a selection using the number boxes?
Bottom grey number on the left is what I'm trying to tweak. Over the last 12 months, I've sold 663 units for a total of $4,107,840 (bottom two green #'s). I need to sell 118 more (top grey #). Ideally, I want that bottom grey box to not show me the average per, but a sum total of the averages. So $4,107,840/663 = 6196 * 118 = $731,128. Any one have an idea on how to get there?
I thought maybe build that value into the base itself somehow, but I'm having trouble running sums within the individual records so they all return the 6196 value in real time (or close to it)...
@Mike_Buck I extended my author/book example base to get that data. By linking records and using rollup fields, you can get the average selling price. I think use a "title in the works" field to multiply by the average royalty to get the potential royalty.
