Forum Discussion

ShivaPrasad's avatar
ShivaPrasad
New Contributor III
22 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 co...
Cube View
Reports
MikeG's avatar
MikeG
Contributor III
20 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