Forum Discussion

SHerbst's avatar
SHerbst
New Contributor
22 hours ago
Solved

Reporting expenses as negative instead of positive

We are converting from HFM to OneStream.  We set up HFM so that expenses are reported as negative.  My understanding is OneStream only reports/stores expenses as positive.  Is this accurate?
Cube View
Parameters
Reports
  • rhankey's avatar
    rhankey
    21 hours ago

    This is readily addressed by creating a dynamically calculated U8#NaturalSign member, which flips the sign of Expense and Asset AccountType's.

MG's avatar
MG
Community Manager
21 hours ago

There are also many customers who are storing expenses as negative values and report them as such. Take a look at the Account type setting on the account members - if you set up your expense account members with the account type "Revenue", you can then load / display your expenses as negatives. Most of the projects I worked on (Europe based) would do this.