3 Replies Latest reply on Jun 9, 2015 5:57 AM by Samet İlhan

    Calculated field for groups

    alex.thumba

      Hi,

      I am trying to create a new calculated field (New Field)  based on another two fields (Month Status &year Status).

      the new field condition is for each 'year' and each 'account' , if 'year status' is 'closed' and month status is 'new' at any month and 'closed' at any month of the same year the new field should be ' new and closed for that whole year otherwise 'new field' should be same as 'year status'.  Is there any way to achieve that??

       

      Attaching sample data in excel here..

       

      Thanks