Forum Discussion

ShivaPrasad's avatar
ShivaPrasad
New Contributor III
12 hours ago

Row Formula is overring Ud8 Calc

Hi Team,

In our report we are having multiple formula's in row and columns (Can't apply the row or column overrides). So, have created a UD8 Dynamic calc. though after applying the UD8 member in column, row formula is overring the UD8. Can please help us to resolve the issue.

 

Cube View
Reports

2 Replies

  • MikeG's avatar
    MikeG
    Contributor III
    10 hours ago

    Dim povPriorYearQtr As String

     

    Dim acct As String = api.Pov.Account.Name

    Dim amt As Decimal = api.Data.GetDataCell("(A#" & acct & ":U8#Top - A#" & acct & ":T#" & povPriorYearQtr & ") / A#" & acct & ":U8#Top:T#" & povPriorYearQtr & ")").CellAmount

     

    brapi.ErrorLog.LogMessage(si, "U8 Dynamic test: Ent= " & api.Pov.Entity.Name & ", acct= " & acct & ", povPriorYearQtr= " & povPriorYearQtr)

    Return amt

  • MikeG's avatar
    MikeG
    Contributor III
    10 hours ago

    Hi ShivaPrasad​ give this a try and see what is returned in the ErrorLog.  You need to add additional dimensions I would think, this here is starting with which Account you are looking to calculate.  api.Pov.Account.Name is the datacell POV of the Account of your CV intersection for that datacell.