I have a Profit & Loss Report.
Profit Margin is (Revenues - Total Cost) / Total Revenues.
For sub summaries and report totals I need to use the Get(Summary) function.
This has alway been annoying but tolerable. Until now, when it has become real problem.
The Get(summary) function must use an indexable field. So if I want a sub summary by Producer Name I have to use a lookup. Lookup are something I avoid whenever possible.
Are there alternatives to get(summary)