5 Replies Latest reply: Jun 7, 2013 9:17 AM by Yannick Durand RSS

    complex count

    Yannick Durand

      Hi,

      Let's imagine I have this data structure :

      ProjectPeriodeStatus

      1

      1

      A
      12B
      21A
      22A
      31B
      32C












      How do I write a formula to calculate the number of projects which are in status B in Period 2 and were in status A in Period 1 ?

       

       

      Thank you !