This is the expression what i have
if(Len([Parent Policy])=0 and UW_YEAR<Year(Today()) , 'new', if(UW_YEAR<Year(Today()) and Len([Parent Policy])>0 , 'lost', 'renew') )
but this expression did not working
data is like
Child policy parent policy Year Status 12 - 2018 Lost
this means that this child policy not exist in current year (2019) and also dont have parent policy (parent policy means this policy not coming from previous year like 2017, 2016 etc ) so this should be lost
if this policy coming from previous year and parent policy is exist then status is renew but if this policy not exist in current year then last record should be lost
Child policy parent policy Year Status 12 456 2017 renew 124 12 2018 lost
and other condition is when policy exist in current year then those all policies should be new
Child policy parent policy Year Status 12 456 2017 renew 124 12 2018 lost abc-12 - 2019 new anx-1345 - 2019 new
so how i modify expression according to these conditions