Automate Formula

[SJ_16]

Hi,

Any idea how I can automate the formula below please so I don't have a hard coded date? This will always look at previous year.

RangeSum(Above(Sum({<[Country] = {'UK'}>}if(Left(DATE_IN,4)='2017'
and Lookup='Renewal_Value',Val)),0, RowNo()))
/
RangeSum(Above(Sum({<[Country] = {'UK'}>}if(Left(DATE_IN,4)='2017'
and Lookup='due for renewal' ,Val)),0, RowNo()))

[SJ_16]

I haven't done it that way as I don't know how to write the script so i was hoping I could just change the formula I already have

[sunny_talwar]

Would you be able to share your app or a sample to help you better?