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

    Calculated field fixed by date

    Alexis Jensen



      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