I am trying to pivot the org code and the End lease liability balance to know the sum of the end lease liability balance for each org code.
However in the manual aggregation tab, I cannot locate the column end lease liability balance to sum up the data.
Can I know what is my error?
hi @TLKNW
to do the aggregation sum you should change your ‘string’ column to number.
rgds
sorry how to do that?
before connecting the pivot node, attach either a string-to-number node or a table-manipulator node and select the column that you need to change to a number for the calculation.
rgds
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
