Hi Experts,
Can any one please help me on below requirement.
I have to create one new field from below mentioned 4 fields (Entity, Feedback, Start date and end date ) named [T/N Product] with 2 records i.e., Trending Product and Non Trending Product records
based on existing fields condition using if match expression.
Conditions:
if Entity = Sales then Trending Product
if Entity = Manager then Non Trending Product but only if Feedback = Yes else Trending Product
If Entity = Products then Non Trending Product but only if Feedback =No and (End date -start date)<=3years
if Entity = Rating then Trending Product
if any new field added at Entity it has to be treated as Trending Product
Entity Feedback Start date end date
Sales Yes 01/02/2015 05/01/2018
Manger No 01/02/2017 05/01/2018
Products 01/02/2017 05/01/2018
Rating
Please help me on this.
Thanks in advance.
