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.
Where did you put the formula value*-1? If you put this formula in account conversion file then maintain transformation as follows :
CONVERTAMOUNTWDIM=c_accnt "Account dimension
amount=<account conversion file>.xls
c_accnt=<account conversion file>.xls
hope it helps...