sign flip in complex expression
When loading data, all of our accounts from source match the names of the account in OneStream so we've always used a *:* rule for the account maps. However, we have a new dataset coming in and we ne...
Forum Discussion
Do all your revenue accounts start with the same number? Without knowing all your existing transformation rules, you could consider do a Mask type Transformation Rule like this example below:
For reference, our source system's accounts align exactly with OneStream. We have to do flip signs on various account types. Revenue comes out negative in the source system, so we flip sign in OneStream as seen above.
My existing rule is *:* but, alas, my account numbers are not that consistent. I did a quick comparison and I have revenue accounts for almost every number.