cancel
Showing results for 
Search instead for 
Did you mean: 

Conversion File - JS

former_member623
Participant
0 Kudos

Hello,

BPC 10.1 NW on HANA

EPM Addin SP30

when the amount is >0 i want to load it to Acct1 else Acct2.

In source data (infoprovider) we have negative sign in the end (1000.00-) so the conversion file is treating it as a string instead of numeric value.

is there a way to fix this?

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

former_member623
Participant
0 Kudos

it works after changing formula as below:

js:Number(%external%) > 0 ? "AR_WRITE_OFF" : "AR_RECOVERY"

former_member186338
Active Contributor
0 Kudos

Sorry, but I am unable to understand what are you doing!

%external% in your conversion file will contain Account member ID from BW, not the value.

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

Please post full info:

transformation file

name of conversion file?

If you want to work with value you have to use FORMULA column, but you can't change target account here...

You can load data to single account and then run script (may be in default.lgf) to copy data based on sign.

former_member623
Participant
0 Kudos

When i test it with simple data file it works ( -ve sign in the front or at the End)..but it doesnt work when i load from infoprovider

former_member186338
Active Contributor
0 Kudos

Sorry, but I can't find a relation between your transformation file and conversion file!

Please read again my answer.

former_member623
Participant
0 Kudos

Hi vadim,

Here is the CONV file

former_member186338
Active Contributor
0 Kudos

Sorry, but I do not see full text of transformation file!

former_member623
Participant
0 Kudos

Transformation file:

former_member186338
Active Contributor
0 Kudos

Sorry but your conversion file will convert the account ID, not the value!

Read again my first answer:

You can load data to single account and then run script (may be in default.lgf) to copy data based on sign.


former_member623
Participant
0 Kudos

but it works when i load from a flat file..it doesnt work when i load from infoprovider

former_member186338
Active Contributor
0 Kudos

I have no idea what are you doing with flat file but for your current setup it will not work!