Forum Stats

  • 3,733,800 Users
  • 2,246,822 Discussions
  • 7,856,877 Comments

Discussions

Dynamic rule referencing a different account depending on frequency

IGM
IGM Member Posts: 20 Blue Ribbon

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

Tagged:

Best Answer

  • Jeo123
    Jeo123 Member Posts: 508 Gold Badge
    Accepted 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

  • Jeo123
    Jeo123 Member Posts: 508 Gold Badge
    Accepted 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"

Sign In or Register to comment.