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:
Organizations:
January 2016 8
February 2016 10
March 2016 9
April 2016 12
etc etc
Can someone help me please?
Thank you!
Sandra,
Please see if these resources may be of assistance:
The specified item was not found.
Vizible Difference: Taking Stock with Start and End Dates
http://redheadedstepdata.io/lookup-vs-transactional/?content=Reference+Post