Consolidation Error: Error executing VBScript Microsoft VBScript runtime error, Line 393:Type mismat
Hi,
I am trying out the use of calc manager and I moved our classic RLE file into it. I've validated and checked for syntax errors and says there's none so i deployed it. I ran a consolidation but then the process aborted due to a VBscript error.
Error executing VBScript Microsoft VBScript runtime error, Line 393:Type mismatch: 'pov_year'
Script Snippet:
Sub Calculate_Translate()
pov_year = "HS.Year.Member"
pov_period = "HS.Period.Number"
'*******************************************************************************************************
'Translate subroutine to override the standard HFM calculation
'*******************************************************************************************************
dim BSAcct
dim USOvd
'Translation logic for C3 OPEN member
BSAcct = HS.Account.List("BALANCE_SHEET", "[Base]")