Percentage format issue

Options
MoraruD
MoraruD Member, ALL USERS Posts: 2 New Contributor
in 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:

Comments

  • Jitendra.Vishnolia
    Jitendra.Vishnolia Member, ALL USERS, GroupMember, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

    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

  • MoraruD
    MoraruD Member, ALL USERS Posts: 2 New Contributor

    Thanks a lot @Jitendra.Vishnolia.

    Indeed I have missed this step. Now everything works properly!

Categories