Age Calculation

[hitha1512]

Hi Team,

I have a requirement to calculate the Age. 

Requirement - 

Compare field "Agreement Name" with last business days "Agreement Name" data. If new, then = 0, If was in the previous report, then +1 to the existing Days OLD count. If the agreement name drops off the report and appears the next day the count would restart from 0 again.

attaching raw data files and the results required.

Note : we receive daily files and there can be cases where we might not receive files 

thanks for your help in advance.

Regards,

Hitha Dhani

[hitha1512]

Fabulous ! thanks a ton for your quick response 🙂 Much appreciated !

[hitha1512]

Hi Tresesco,

the below solution worked. but now i have been asked to exclude the Public holidays and weekends. please see my explanation below.

I receive excel files daily except on weekends and public holiday. so for these days i dont have the date populated in application.  

Please refer the attached screen shot. for 28/01/2020 the age expected is 1,  as 27th was public holiday and 25 and 26 were weekends. I do not have 25,26,27 populated in the dashboard. 

your code is checking for the previous day. 

-------Floor(valuation_date-Peek(valuation_date))=1,

what i want would be based on file. if the previous file that i received has the agreement name or not. 

would appreciate if you could help 🙂

Thanks & Regards,

Hitha Dhani