'Formula to extract unique records in the last 2 weeks

I have the following coding below, however I am wanting the report to sum the number of unique absences for the previous 2 weeks. Is there something I can add in the SUM formula that says extract the information for the last 2 weeks, as currently I'm having to do this on a daily basis.

if (Not IsNull(DistinctCount ({COVID_19_Absence_Report.Person Number}, {COVID_19_Absence_Report.Job Group}))
    and DistinctCount ({COVID_19_Absence_Report.Person Number}, {COVID_19_Absence_Report.Job Group}) > 0)
then 
    100 * Sum ({COVID_19_Absence_Report.COVID-19 Assessment Done}, {COVID_19_Absence_Report.Job Group}) /
    DistinctCount ({COVID_19_Absence_Report.Person Number}, {COVID_19_Absence_Report.Job Group})
else
    0

Thanks in advance for who ever looks into this for me.

crystal-reports

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Formula to extract unique records in the last 2 weeks

Sources

Related Questions