PieterDR
2 years agoNew Contributor II
Sum two columns in a datasource
Hi all,
In my delimited upload file (trail balance) there are two columns that include amounts: beginning balance and the sum of periodic movements. The sum of the two is the number I want uploaded in the import stage.
Is there a way to make OneStream add an additional calculated column (source dimension) to the datasource with the sum of the two columns (so prior to transformation / validate / process)?
Any help would be much appreciated!