7 Replies Latest reply: Mar 17, 2013 6:29 AM by Stefan Wühl RSS

    Problem: Calculation in load script using EVALUATE doesn't work

      Hi all,

       

      I try to load data from an auditfile. In the auditfile the debitAmount and the creditAmountfield is text.

      I used the EVALUATE function in my loadscript to convert them to numbers. That's okay.

      But after that, I tried to make a calculation in the LOAD script: EVALUATE (debitAmount) - EVALUATE (creditAmount) as Amount

      That doesn't work. It seems that EVALUATE is not useful to calculate (a calculation EVALUATE (debitAmout) + 100 works fine but a double EVALUATE in the calculation doesn't work).

      How can I realize the calculated field Amount as the difference between debitAmount and the creditAmount?

      I hope you have the solution.

       

      Regards,

      Rudy