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

[pooja_prabhu_n]

Hi,

Calculate the days difference in the script level.

if(Absence_Emp=Peek(Absence_Emp),Date_Absence- Peek(Date_Absence),0) as Days_diff

Directly use Sum(Days_diff) in the Text box.

as far as i know, use of Above function directly won't work in Text box.

Thanks,

Pooja

[jyothish8807]

Hi Steeven,

Please find attached.

Br,

KC