Hello!
I need help on a formula that outputs a count and a sum since we are unable to build formulas from a gantt chart.
This is the formula page I am using in order to build a gantt chart with a bar chart in a dashboard with month counts and sums.
I created this report to show what is needed in the formula.
Count:
Count of location for the first month of April 2020 = check to see if April 2020 (column 8) is a month within Repayment Period Start and Repayment End. If yes, count it towards the April 2020 count of locations. But also making sure it looks at everything in the "What" filter.
SUM:
If yes above, add the amount to the additional $ amount column.
The months in column 8 go all the way until 2026.
Thank you in advance!