How to SUM between a Date Range?

[ericp]

Please see the screenshot. I have a table with years associated to values. I want to separate the SUM of 'All Years' vs 'Active Years'. For example if I say my 'Active Years 'are between 2020 and 2024, how can create the formula to ignore the values with the Year 2019?

[Lech Kulikowski]

Hello,

Please try to use the SumIf() function. Something like:
SumIf(datasource.column, (datecolumn >= 2020 && datecolumn <= 2024))

Thank you.

[ericp]

So this is the function I tried (in the Total column) and it doesn't seem to be working:

{SumIf(currentProjectRevision_ProjectRevisionFunding.Total), >=(currentProjectRevision.FiscalyearStart) && <=(currentProjectRevision.FiscalYearEnd)}

My datasource:
currentProjectRevision.FiscalyearStart = "2020"
currentProjectRevision.FiscalYearEnd = "2024"

[Lech Kulikowski]

Hello,

Your expression is not correct, should be:
{SumIf(currentProjectRevision_ProjectRevisionFunding.Total, (YOURDATACOLUMN >=currentProjectRevision.FiscalyearStart && YOURDATACOLUMN <= currentProjectRevision.FiscalYearEnd))}

Thank you.