Flipping a Sign

Forum|Forum|1 year ago
July 11, 2024
1 reply
3 views

Hello,

I just need help flipping a sign on a final report.

Here is the data:

Here is the report (there is a negative sign in front of the number insert):

And here is what my OneStream is showing:

I went into transformation rules and flipped the sign on those 2 accounts, but that did not help:

Does anyone have any suggestions? Thank you!

Application Properties

T

T_Kress

My first question is, what do you have as your account type for 30001 and 30002 in OneStream? Assuming those are type: Revenue, and that when the data comes in from an ERP it is naturally a credit balance, you will want to flip the sign of those 2 (or any revenue or liability) accounts in your transformation rules so that they show in OS as positive.

This is because OS is a reporting tool, not a ledger tool so revenue and liabilities in OS naturally show as positive, even though in the ERP they are natural credits.

After flipping the sign in transformation rules and reloading your data, you will then want to consolidate.

If you follow those steps those 2 accounts (or any revenue or liabilities) will show as positive on OS reports.

If you are trying to create a trial balance view with debits and credits, you can write a dynamic U8 calculation that will flip your OS type revenue and OS type liabilities on reports back to show credit balances. But that is typically done via a dynamic U8 as shown below:

W

wm2Author

I needed to re-upload the data thank you very much.

Last thing, how can I get Tot Rev - COGS instead of them adding?

T

T_Kress

Again, it should work assuming TOT REV is type: Revenue and COGS is type: Expense. The two positive numbers in OS will naturally subtract. It is all based on account type.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded