I am relatively new to Crystal but I am learning quick. I am trying to have a SUM of a field appear using a specific date array built into a formula. Below I will show my code and explain things a little better.

These first 2 formulas get me the first day of the month and the last day. I have several of these for going back several months.

@11BackBeg

Local DateTimeVar d := {TimeRecord.ActualDateTime};
DateSerial(Year(d), Month(d) - 0 - 11, 1)

@11BackEnd

Local DateTimeVar d := {TimeRecord.ActualDateTime};
DateSerial(Year(d), Month(d) - 0 - 10, 0)

Now I have a formula to get me the range I want to pull from - I need a way to tell it where I want to pull from and for who, so I have.

@11Back Time

{TimeRecord.OwnedBy} = {?AS Team Member} and
{@ActualDate} in {@11BackBeg} to {@11BackEnd}

So I need to make the SUM of the field display for in between these dates, I am unsure how to write the SUM function. I currently have whats below but need a little help making it work.

Sum ({@F AdminTime}, {TimeRecord.OwnedBy})

I appreciate all your help, thank you.