1 Reply Latest reply: Jun 15, 2018 7:21 AM by Sunny Talwar RSS

    if logic help in front end

    Mahitha M

      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.