Row Formula is overring Ud8 Calc

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.

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

Hi Mike,

Thank you for the replay, we have tried your code but still row formula is overring the UD8 which is given in column.

Please see the below brief. My Account 1 & Account 2 are from two diffrent parents levels. and here am pulling variance between those at row 5 (Account Var). at d column D have applied UD8 with given code (2nd screen shot). here we should get value 67%(D5). but row formula is overriding the column UD8 Member, Please refer the 3rd screenshot. Kindly help us to resolve this issue.

Note: Since row is having a formula, account is not picking any value default it is taking as TOP. We tried with this line "Dim acct As String = api.Pov.Account.Name" and it is not printing anything in error log.