IN my Profit & Loss reporting I need to calculate margin in the summary lines.
To do this I need to use the GetSummary.
getsum(Cost_Sum, Client name) / gets(Revenue_Sum, Client name)
....if the sort by field is from a different table it does not work (in the above it client name)
....if I make the field a Look Up to get it local it does not update when things change.
So I use a look up which I refresh when running the report
This add a lot of time to running the report.
Any advise of better way to do accomplish this.