Moving Summary Data from one table to another
I have a Summary Field as a running total in one table. I have placed this field also on a second layout which has data from a second table. I want the running total from the first table to appear in the layout for the second table. So far it is only giving me discrete values for records that have a value but it is not giving me a running total of those values. Is there a way to do this?
I have tried using look-ups and calculations to pull the information from the first table into the second table but they always leave blank fields on the records that have no values rather than giving me the running total number that appears in the Summary Field of the first table.
I hope this makes sense.