Skip to Content
0
Jul 09, 2019 at 10:16 AM

Calculating Sum for days between

311 Views

HI Experts,

I created a variable for days count

=DaysBetween([Billing Date];CurrentDate())

and its fetch correct values . but i want sum of days count (4689) in single line in webi . how can i get it.

and i used a formula =Sum(DaysBetween([Billing Date];CurrentDate())) for sum but it fetch wrong values.

Wrong values

Please help me..

Attachments

untitled1.jpg (70.9 kB)
capture4.jpg (11.4 kB)