3 Replies Latest reply on Apr 15, 2018 9:59 AM by Vijay Alluri

    how to calculate a boolean calc field for current value and previous value

    Vijay Alluri

      Hello,

       

      please find attached the workbook, I am trying to calculate current quarter and previous quarter boolean calc fields. I need a calc field as a boolean calc field for previous quarter as "previous quarter" which is FY18Q4.

       

      To explain the dataset I have :

       

      Flag: Y/N - the value is set to Y for the current quarter and N for rest of all the values

      Weekend date: the weekend dates for a given quarter

      Fiscal Quarter: Quarter values.

       

      can you help on how can I used LOD to create a calc field for identifying the "previous quarter values"