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.
