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
Dynamic rule referencing a different account depending on frequency

Hi,
I am trying to write a dynamic HFM rule which would reference a different account depending on frequency,
For Periodic View I'd like the account KD402450 to be divided by account KD402200 but for YTD view it should be divided by account KD402210. Is this possible? The following code does not seem to work for me - account KD402210 seems to be used for both frequencies.
Sub Dynamic_KDs(bLog)
HS.Dynamic "A#KD402310.V#Periodic = A#KD402450.V#Periodic/A#KD402200.V#Periodic"
HS.Dynamic "A#KD402310.V#YTD = A#KD402450.V#YTD/A#KD402210.V#YTD"
End Sub
Best Answer
-
It is definitely possible. We use different accounts for our Share count for example. I think your problem is that you're using V# which is the Value dimension instead of W# for View. Below is an example from our app.
HS.DYNAMIC "A#Shares_Basic.W#QTD = W#QTD.A#SharesQTD_Basic"
HS.DYNAMIC "A#Shares_Basic.W#YTD = W#YTD.A#SharesYTD_Basic"
Answers
-
It is definitely possible. We use different accounts for our Share count for example. I think your problem is that you're using V# which is the Value dimension instead of W# for View. Below is an example from our app.
HS.DYNAMIC "A#Shares_Basic.W#QTD = W#QTD.A#SharesQTD_Basic"
HS.DYNAMIC "A#Shares_Basic.W#YTD = W#YTD.A#SharesYTD_Basic"