1 Reply Latest reply on Jul 27, 2017 5:57 PM by swaroop.gantela

    Count unique active organizations by month

    Sandra Ragues

      Hi all,


      I am trying to build a formula that will show me all active organizations by month.

      I basically have the following:

      - Organizations (example: AMEX)

      - Start date of the contract (Example: 10/06/2015)

      - End date of the contract (Example: 18 / 10/2018)


      I want this organization to appear on my report for all the months between the start and end date.


      Ideal Scenario:


      January 2016               8

      February 2016             10

      March 2016                  9

      April 2016                    12

      etc                                etc



      Can someone help me please?


      Thank you!