AnsweredAssumed Answered

Running totals across portals

Question asked by nkolios on Feb 6, 2017
Latest reply on Feb 7, 2017 by philmodjunk

I have a database which records lots of information as a daily record with child records that all have the Date record as the parent record.  One of the things that I keep a log of is our daily cash movements.  We used to just keep a long list which is a bit cumbersome and prone to errors so I have now set up a child record of cash movements but  still need to keep a running total.  The idea is that entries are made in a portal and not a report layout but I can not get the portal records to update because the summaries and calculations only look at the current context, i.e the records on that particular day.  Is there a way to do this, maybe I need a different relationship. 

 

I know I can probably send the script to the list view do the calcs and then come back again but it seems over complicated.  I have uploaded an extract from the relationship diagram.

 

Many thanks

 

Niko

Attachments

Outcomes