Jump to content
  • 0

daily calculations



I would like a table that can pull information from another and give me daily numbers 

I know this would be a task to run every morning or possibly a pivot table

1. Give a total of new entries from the previous day

2. The total number of incomplete work items in total (from a check box field)

3. Number of projects completed the previous day (From a check box field)

4. The average time that work is out (From a calculated field run through a task


Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

I have a similar problem that I am trying to tackle. I want to perform calculations on a table everyday. Essentially, some of the records in my table will have the same reference number and I want to add up the columns of the records that have the same reference number.

Please let me know if you find a viable solution to this.

Link to comment
Share on other sites

  • 0

Hello @Kurtmc,

Since I don`t know your table design, I will share an example based on my test tables.

Let`s say there is a Table that stores orders:


As you can see, there are 5 orders from yesterday, 2 of them are completed, and 3 of them are incompleted.

The Table to store totals from the previous day:



This Task populates the 'Orders_totals_daily' table on the daily basis.




Hope this helps. 

Link to comment
Share on other sites

  • 0

Hello @brennanpoit,

For your case, the Task design might be simpler.

First of all, you may want to check an article regarding Tasks:


For example, there is a table that stores unique invoices:


And there is a second table (the so-called Child table that can store multiple records related to the invoices):


As you can see, these tables have a relationship based on the ID field. 

This is the Task example to count the number of each invoice and the sum of each invoice in the Invoices_tbl.






Feel free to update this thread if you have further questions. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...