Skip to Content
0
Former Member
Jul 22, 2010 at 02:11 PM

Tranformation Files - Easy Question - Please Help

24 Views

I have a transformation file that I am using to load a full year data file. I have one account that I need to flip the sign on. The proper formula is in the conversion file for this account. When I run the package to import the data, the sign only flipped for the first month, not for all 12 months. Obviously, I have an incorrect formula somewhere.

In the Conversion file, my formula is value*-1

In my Transformation file, I have the CONVERTAMOUNTWDIM= specified in the first section

I have Time=*MVAL(3:14) to indicate the 12 months of data in my file in my options

I have Amount=FRCST Conv.xls!frcstacct and TIME=FRCST Conv.xls!frcsttime for the amount formula in the conversion section

I believe the problem is possibly that I don't have amount specified in the options section but I am not sure what formula.

I am sure I am overlooking something simple, any ideas are definitely welcome.

Thank you!