Forum Stats

  • 3,826,835 Users
  • 2,260,712 Discussions
  • 7,897,090 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: 515 Gold Badge
    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: 515 Gold Badge
    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"