I’m trying to sum a column within a datatable but not all the fields. E.g. the datatable consists of column, project name, project number, document type, debit amount and credit amount. I want to sum all the value except those with document type ‘journal’. Also, I’ve tried several formulas posted but I don’t know how to apply the where in the formula.
Any and all help would be appreciated.