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
Solved
Sign Switch on Matrix Data Source
I have a delimited data source as matrix data to fetch opening, debit and credit flows.
The credit amount comes in as absolute, and I need to factor it with *-1, but opening and debit flows must re...
Hey JustinHoppe ,
I'm presuming you have something similar to this screenshot, with 3 Flow Dimensions in your DataSource? On the Amount field, add a Complex Expression that checks if you're parsing the Credit column (in my example, this is column #5), and flip that value. Make sure you check the api.ValueIsNumeric before doing this so you don't try to flip sign on the Column's header text.
Hey JustinHoppe ,
I'm presuming you have something similar to this screenshot, with 3 Flow Dimensions in your DataSource? On the Amount field, add a Complex Expression that checks if you're parsing the Credit column (in my example, this is column #5), and flip that value. Make sure you check the api.ValueIsNumeric before doing this so you don't try to flip sign on the Column's header text.
Thanks Darryl, the .DimensionDelimitedPosition was exactly what I was looking for.
