SAP BPC : Formula in conversion file doesn't work

[former_member606751]

Hi Experts,

I need your advice. Here below my conversion file :

When I load my data, the formula doesn't work at all. I thought maybe it was due to the amount decimal point. Here the amount decimal point is "," and not "."

I tried to change "." by "," but the result remains the same = doesn't work

Any idea on what would be the issue ?

My transformation file :

Kind regards.

[former_member186338]

Your transformation file is incorrect!

What is the dimension used in conversion file?

[former_member186338 · Accepted solution]

To correct it you will need:

Add line to *OPTIONS:

CONVERTAMOUNTWDIM=NATURE

In *MAPPING replace:

SIGNEDDATA=*COL(12)

with

AMOUNT=*COL(12)

In *CONVERSION add line:

AMOUNT=NATURE.XLS

Then your formula will work!

[former_member606751]

Hello Vadim,

How my transformation file could be incorrect ? data load works fine

The dimension used in conversion file is : Nature (= account in english)

Regards