Skip to Content
author's profile photo
Former Member

Please help with UDF

Hi,

Can anyone please help with a user defined function to do the following:

I have a file that comes in looking like this

ROW 1

- Transaction Type = Z1

- Total = 100

ROW 2

- Transaction Type = Z2

- Total = 200

ROW 3

- Transaction Type = Z3

- Total = 300

ROW 4

- Transaction Type = Z4

- Total = 400

ROW 5

- Transaction Type = ZZ

- Total = 800

When I do my graphical mapping I want the total for ROW 5 where Transaction Type is ZZ to be:

(Total of ROW 5) - (Total of ROW 1) - (Total of ROW 3)

Please help,

Regards,

Liesel

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 08:00 AM

    Hi,

    Why UDF? you still can achieve using graphical mapping... can u explain a bit elaborative?

    regards

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 27, 2007 at 07:58 AM

    Hi leisel,

    Use standard function COUNT to solve ur mapping issue

    Add comment
    10|10000 characters needed characters exceeded