synergy46

Portal Filtering and Calculations...

Discussion created by synergy46 on Aug 6, 2014
Latest reply on Aug 8, 2014 by synergy46

I am using FM 13 adv

I have read this discussion and found it useful: https://fmdev.filemaker.com/message/87572#87572

 

However, my situation calls for the summarizing of filtered portal information (which works... thanks for the posting) AND the combination of the summarized portal information with other fields.

 

Here is the layout

PortalReconcile.png

Note: The Checks Out: and Deposits Out and summary fields located in a second portal that filters the same as the lower portal. This works great...

However, what I need to do is: The user enters the Balance Per Stmt (yellow) and then the calculated field 'Balance Per Stmt...' subtracts 1200 and adds 100. This does NOT work when placed in our out of the portal...

 

globals.png

Thanks for your ideas.... Ron

Attachments

Outcomes