The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Grace_Johnson's avatar
Grace_Johnson
New Contributor
1 year ago

Troubleshooting FlipSign

Hi all, I'm trying to build a trial balance that shows line items in their natural debit/credit balances (e.g. - revenue, liabilities, and equity showing up as negative, and all else showing up as ...
Cube View
Campbell's avatar
Campbell
New Contributor
1 year ago

Use code in UD8 - Flips sign back to natural sign

Example Code:

'This calculation flips the sign back to natural sign based on the account type
  
Dim acct As String = api.Pov.Account.Name
Dim acctTypeName As String = api.Account.GetAccountType(api.Pov.Account.MemberId).Name
  
If (Not acct Is Nothing) Then
        If acctTypeName.XFEqualsIgnoreCase("Liability") Or acctTypeName.XFEqualsIgnoreCase("Revenue") Then
        Return api.Data.GetDataCell("A#" + acct + ":U8#None * -1")
        Else
        Return api.Data.GetDataCell("A#" + acct + ":U8#None")
        End If
End If
  
Return Nothing