SUMIf date is between [daterange controller]

6

I think this is what you were looking for :slight_smile:

For the Price

Tasks.Filter([Done date]>=[daterangepicker 1].First() AND [Done date]<=[daterangepicker 1].Last() AND Epic.[Epic Name]=thisRow.[Epic Name]).Price.Sum()

And for the Duration

Tasks.Filter([Done date]>=[daterangepicker 1].First() AND [Done date]<=[daterangepicker 1].Last() AND Epic.[Epic Name]=thisRow.[Epic Name]).Worked.Sum()

I don’t know why but I had to rewrite the formulas to get them to work.

2 Likes