Above Aggr issue

[steeramp]

Hello ,

I have an issue , I want to sum numbers of days between "Date absence" , Example

employe 349 : ( ("08-02-2018" - "01-02-2018") = 7days       +   ("13-02-2018" - "08-02-2018") = 5days) = 12days

employe 395 :  ("16-02-2018" - "15-02-2018") = 1days

employe 433 :  ("27-02-2018" - "26-02-2018") = 1days

employe 533 :  ("15-02-2018" - "14-02-2018") = 1days

What I want to have report  in one TEXT BOX the sum of this values .... then 15 days

How I can do this ?   THANKS SO MUCH

[YoussefBelloum]

Hi,

Interesting.. but don't think it is possible directly on a text object without some calculations on the script..

Maybe stalwar1‌ can take a look here ?

[sunny_talwar]

May be this

=Sum(Aggr(Max(Date_Absence) - Min(Date_Absence), Emp))