AnsweredAssumed Answered

Get summary based on remote fields

Question asked by user28271 on Jan 14, 2018
Latest reply on Jan 14, 2018 by keywords

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.