3 Replies Latest reply on Sep 27, 2018 11:43 PM by Tushar More

    Calculated field fixed by date

    Alexis Jensen

      Hi,

       

      I have data with 2 periods under a dimension date listing the number of team members in each manager's team.  I need a calculated field that basically says:

       

      IF # members in current month >0 and # in previous month =0 then Y else N.

       

      I can't quite get it to work.

       

      Any suggestions greatly appreciated

       

      Regards,

      Alexis