Skip to Content

Conversion File - JS

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.

conv.png (4.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 15, 2017 at 09:32 PM

    it works after changing formula as below:

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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 12, 2017 at 04:35 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded