Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Function to identify /Allocate next 11 months based on current month

User_N9Z3I
Member Posts: 216 Blue Ribbon
I have a requirement to calculate data for current + 11 months
If Currmon = Jan
Jan = 75% of 100
Feb:Dec = 25% of 100
If Currmon = Feb
Feb = 75% of 100
Mar:Nextyr->Jan = 25% of 100
IF Currmon = Mar
Mar = 75% of 100
Apr:Nextyr->Feb = 25% of 100
Can anyone help me with the functions to auto calculate next 11 months .
Tagged: