Skip to Content
0
Aug 04, 2023 at 08:58 AM

Sum of Variable using datesbetween

89 Views

Hello,

I created a variable, [DaysCount].

=DatesBetween([Billing Date];CurrentDate();DayPeriod)

This returns the correct values but I want a sum of days per month. =Sum([DaysCount] returns a total value that is incorrect.

Can anyone tell me what the issue is here and how to resolve it.

Thanks,