Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Converting VB Script syntax to Calc Script syntax

User_1YH3IFeb 27 2018 — edited Mar 1 2018

Hi Experts,

Im new to calc script , I have one requirement that I need to convert VB script into Calc script which I can use in calc Manager. If anyone have any idea please provide suggestion.

Sub ICPAdj()

   

    IF HS.Entity.IsBase("", "") Then

        If HS.Value.Member = "<Entity Currency>" or .Value.Member = "<Entity Curr Adjs>" Then   

            AcctsFS = HS.Account.List("Statement_of_Financial_Position","[Base]")

   

                For Each Acc in AcctsFS

       

                    If HS.Account.IsICP("") Then

                        'Do Nothing

                    Else

                        HS.Clear "A#" & Acc & ".I#[ICP None].MV#IC_BAL"

                        HS.Exp "A#" & Acc & ".I#[ICP None].MV#IC_BAL = -1*  A#" & Acc & ".I#[ICP Entities].MV#IC_BAL"

                    End If

                    End Sub

Thanks,

RK
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2018
Added on Feb 27 2018
#business-intelligence-applications, #financial-consolidation, #performance-management-applications
3 comments
256 views