Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)

MOSC Banner

Script not working

Hello,

I write a script that is not working. The error message is "wrong character". Below is the script:

Fun:

 

Dim dblVal

 

dblVal = ABS(|,,,,,,Assets,[ICP Top],TotC1,TotC2,TotC3,TotC4,,,,,,,,,,,,,,,,| - |,,,,,,LiabEq,[ICP Top], TotC1,TotC2,TotC3,TotC4,,,,,,,,,,,,,,,,|)

 

If dblVal < 90 Then

'Passed validation rule

RESULT=True

 

ElseIf dblVal >= 90 And dblVal <= 100 Then

'Pass Validation, raise warning

RESULT=True

RES.PstrCheckMessage1 = "Warning! Trial Balance is out of balance."

 

ElseIf dblVal > 100 Then

'Failed validation

RESULT=False

RES.PstrCheckMessage1 = "Trial Balance is out of balance, please correct!"

 

End If

Can someone show how to fix?

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center