Hi, I am sure I must be doing something wrong but in a column of financial data i have numbers that are positive and negative, when i try to aggregate the column with the GroupBy the output is either 0 or -0.
I have converted the original column from String to Double as there are decimals. I see no errors or warning messages in the Console - Any ideas would be apprecaited
Thanks Mark
It is hard to know without context, but if you are looking at Journal Entries then they would by definition always net to zero because of the accounting principal of dual sided ledgers.
Hi
Not ledgers, simply a set of inputs that are either positive (credits) or negative (debits) which when summed will let me know if I am above or below an expected budget.
I would have thought this was fairly normal
Mark
What’s your expected output? Because if I sum this manually via a calculator it results in zero, what @iCFO also referenced
Do you want to sum the credits and debits separately? Then you need another column to group on that outlines this or use a row splitter and then two groupBy nodes.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.