1 Reply Latest reply: Nov 27, 2012 8:51 AM by JeffJon RSS

    How to use POWN in calculation module

    860325
      Dear All,

      We are trying to use the POWN function in calculation module for 11.1.2.0 but it errors out during consolidation stating incorrect POWN function. We need to get the POWN value to calculate the percentage share by each entity for a specific account.

      The rule runs as follows:

      Dim dPOwn

      dPOwn = HS. Node.POWN("")

      If HS.Entity.IsBase("ABC","") = TRUE Then

      HS.Exp "A#HFM123456.C1#Calc = A#HFM234567.C1#Input * dPOwn"

      End If

      Following combinations have also been tested:

      HS.Exp "A#HFM123456.C1#Calc = " & dPOwn & " * A#HFM234567.C1#Input"

      HS.Exp "A#HFM123456.C1#Calc = "A#HFM234567.C1#Input" * dPOwn


      Can anyone please help us out?