Skip to Main Content

Analytics Software


For appeals, questions and feedback, please email

FDMEE - how to load two columns to make a net amount into amount

Teresa ModestaApr 25 2019 — edited Apr 25 2019


I have a file which gives me a Debit and a Credit column and I need to load Debit - Credit to the Amount using FDMEE.

I thought I could do this with two loads, but after trialling various settings of append / addition on loading I do not get the net result I get if I manually add the two columns and just load the result.

Is there a way to do this with a single load without manually editing the source file?

thank you!

Teresa X.

This post has been answered by JohnGoodwin on Apr 25 2019
Jump to Answer