Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Exclude calculate () from consolidation

Hi,
I wanted to exclude the calculate () routines that i have created in calculation manager when i consolidate. I want to execute calculate manually. How can i achieve this?
HFM version = 11.1.2.4.204
Regards
Best Answer
-
Hi. You cannot run the Calculate subroutine manually - the consolidation process is coded to look for the subroutine and run it. What you can do is set up a switch. Basically, in the subroutine use a GetCell and a If/Then to see if an intersection has a 1 or not. If 1, then End Sub. If not 1, then skip the switch and proceed through the subroutine normally. Alternatively, if you’re using Calculation Manager, you can create a blank ruleset in the Calculate subroutine and then choose whether the blank or the regular ruleset is marked for deployment.
Eric
Answers
-
Hi. You cannot run the Calculate subroutine manually - the consolidation process is coded to look for the subroutine and run it. What you can do is set up a switch. Basically, in the subroutine use a GetCell and a If/Then to see if an intersection has a 1 or not. If 1, then End Sub. If not 1, then skip the switch and proceed through the subroutine normally. Alternatively, if you’re using Calculation Manager, you can create a blank ruleset in the Calculate subroutine and then choose whether the blank or the regular ruleset is marked for deployment.
Eric
-
Thanks for help... what a solution i must say
Regards