AnsweredAssumed Answered

Perform calculations on grandchild records

Question asked by JamesPeragine on May 9, 2018
Latest reply on May 9, 2018 by JamesPeragine

Is it possible to perform aggregate calculations from the context of a grandparent without the need to navigate to the parent layout?

 

My setup

 

Merchants->Merchants_BankAccounts->Statements

 

If the merchant has multiple accounts I want to be able perform aggregates on each Bank Account without leaving the Merchants layout.

 

i.e.  Max (Statements::Date) Max(Statement:Amount)     But for each account only .

Outcomes