Unable to recreate sheet level calculation at the master item level

asmith_rc_23 — Wed, 08 May 2024 14:35:21 GMT

Scenario:

screenshot below (field in question is "transaction tie out")

We have a sheet calculation a former employee created that works as such,

> If( FABS(([Closing UPB] - [Opening UPB]) + [Net Principal Transactions]) = 0, 'Yes', 'No')

variables:

1. [Opening UPB]: Done at master item level, calc -> =Sum({<[Reporting Date History]={'$(=min([Reporting Date History]))'}>} [Principal Gross History])

2. [Closing UPB]: Done at master item level, calc -> =<[Reporting Date History]={'$(=max([Reporting Date History]))'}>} [Principal Gross History])

3. Net Principal Transactions: Created as a master item, calc -> = SUM([Principal Payment Transaction Amount] + [Funding Transaction Amount])
)

Notes:

>the calculation works MOST of the time, there are times when it is set to NO but the tie out amount is zero, this should actually be set to yes and we dont know why

>tie out amount is the integer or amount result of the tie out calc field on the left.

topic Unable to recreate sheet level calculation at the master item level in App Development

Unable to recreate sheet level calculation at the master item level