Seeking some assistance on how to use the rollup function.
I have two tables, one where all the actual data exist ie number of opportunities, one line per opportunity. Can be multiple in a single day. We have a status column to indicate what stage the opportunity is at and in this case i want to rollup status “funded” for a date range…for example month to date.
I have setup a table that has my forecast and for each day what the running MTD target is. What i wish to do is measure for each day the difference between Actual funded for the MTD figure against the forecast for corresponding period.
Example setup is attached but is showing zero so not working.
Look forward to hear of solutions.
Hi Sam, would love to help but could use more information
Could I get screenshots of the following please?
Applications Importlinked field with linked records in it
Applications Importtable with the linked records from the previous screenshot visible, as well as the
And with reference to the screenshots, an example of what you would want the rollup to display
Hey Sam, glad I could help.
I’ve got a vague idea of what you’re trying to do, but could you share a bunch of example data as well as the expected output please? That way I can be sure whatever I give you is exactly what you’re looking for
Hi Sam, thanks for the example. I’m assuming that “month to date” is reset every month. I’ve updated the base linked previously with a solution that should work for your purposes of getting the data in column D, and is powered by the automation “Create links every day”
How it works:
At 12 am every day, it will run and do the following:
Consolidatedtable for the record which has the value
Yesin the field
Is Today?to find the record we need to update
Raw Datatable for records which have the value
Yesin the field
This Month?to identify records with dates for the current month
This will enable us to do a rollup that gets the total for the month that’s correct to that day.
Let me know if you have any questions