Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Teresa ModestaApr 25 2019 — edited Apr 25 2019

Hi,

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
Comments
Post Details
Added on Apr 25 2019
#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting
6 comments
962 views
2 mentions