0
    
          
  
  
    
            Can i use a footer total sum as a field?
Hi there, i was wondering how i can access the sum formula in a column footer as a field in a formula? I have a column called "total paid" in my invoice table which gives me a figure of how much money i have invoiced and been paid from all clients. I am trying to produce another table where i can see how much money i have made in the year to date but i cant figure out how to access the sum figure as a field. Also i was wondering how i would be able to see this figure by selected month if possible. Sorry for the noob questions
1 reply
- 
  
If I understood correctly you need this formula:
sum((select 'Table Name').'Field name')
 
Content aside
- 7 yrs agoLast active
 - 1Replies
 - 2253Views
 
