AnsweredAssumed Answered

Summary Script

Question asked by dbakewell on Apr 12, 2018
Latest reply on Apr 13, 2018 by dbakewell

Team,

I asked this question earlier but gave an incorrect description of my situation.   I need some help setting up the summary tool for “Field 2”.   Please see below, I want “Field 2” to do the following.  Can someone help me with the correct settings? 

 

TABLE

               Field 1 (Pay App)                             Field 2 (Previous Pay App)     Field 3 (Amount Due)

Row1   1# Pay App Total (A)         -              0                                                    = A

Row2   2# Pay App Total (B)         -              Previous Total (A)                       = C

Row3   3# Pay App Total (D)         -              Previous Total (C)                       = E

Row4   4# Pay App Total (F)         -              Previous Total (E)                        = G

Row5   5# Pay App Total (H)         -             Previous Total (G)                        = I

 

Thanks,

David

Outcomes