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)

 

But

....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....

So I use a look up which I refresh when running the report

 

But...

 

This add a lot of time to running the report.

 

Any advise of better way to do accomplish this.

Outcomes