AnsweredAssumed Answered

aggregating (sum) fields - Related Tables - SQL

Question asked by eesiin on Dec 5, 2017
Latest reply on Dec 6, 2017 by philmodjunk

hello

i have this structure and Im using Summary field  , but its very Slow and Summary popup window appear a lot

is there any solution using SQL to speedup the calculation ?

 

 

PROJECT::sum_invoices = 2350 $

                                         -> Region 1::sum_invoices = 850$

                                                                                   -> Service 1::sum_invoices

                                                                                                                ->Activities::sum_invoices (summaryfiled) =700$

                                                                                                                                       invoice1     500$

                                                                                                                                       invoice2     200$

                                                                                   -> Service 2::sum_invoices

                                                                                                                ->Activities::sum_invoices (summaryfiled) =150$

                                                                                                                                       invoice1     50$

                                                                                                                                       invoice2     100$

                                         -> Region2::sum_invoices = 1500$

                                                                                   -> Service 3::sum_invoices

                                                                                                                ->Activities::sum_invoices (summaryfiled) =500$

                                                                                                                                       invoice1     200$

                                                                                                                                       invoice2     300$

                                                                                   -> Service 4::sum_invoices

                                                                                                                ->Activities::sum_invoices (summaryfiled) =1000$

                                                                                                                                       invoice1     600$

                                                                                                                                       invoice2     400$

Outcomes