Percentage format issue

MoraruD
MoraruD
in Integrations and extensibility

Hello Anaplan Community, 

 

I am at the beginning of the training program and have encountered an issue with the percentage formatting while creating several modules in Anaplan.

 

Let me explain : 

I am importing data from a csv file with bonus percentages by department.  In my source file, the value of my bonus % is as a decimal number.

MoraruD_1-1652700927258.png

In Anaplan my Bonus % is in Percentage format. 

MoraruD_2-1652700998172.png

When I am viewing my data however, instead of getting 25% (or 0.25 * 100) my results are 2 500% (or 0.25 *10000)

 

MoraruD_0-1652700912079.png

Can anyone please explain to me how to correctly import my file and format the values so I get the correct percentage?

Tagged:

Best Answer

  • Jitendra.Vishnolia
    Jitendra.Vishnolia
    Answer ✓

    Hi @MoraruD ,

     

    In the Manage Import Data Sources, pls check for the Decimal Separator. It should be set to DOT instead of Comma.

    JitendraVishnolia_1-1652702057124.png

     

    Hope this helps

     

    ~Jitendra

Comments

Categories