Dear Freinds,
My requirement is to change the sign of data while loading the data into BPC using BPC tranformation and conversion file.
I tryied with Convertion formuls
EXTERNAL INTERNAL FORMULA
0080100006 IC_80100006 VALUE*-100
my transformation file
*OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER = ,
AMOUNTDECIMALPOINT = .
SKIP = 0
SKIPIF =
VALIDATERECORDS=NO
CREDITPOSITIVE=NO
MAXREJECTCOUNT=-1
ROUNDAMOUNT=
SELECTION=0GL_ACCOUNT,0080100006;
other things are normally working , Kindly sugesst were I gone wrong .
Thanks !