L1MB 8.5.2 Import Data into Price Book Module

hanhuiwu
hanhuiwu
in Academy Discussions

I'm importing data in activity 8.5.2 in Level 1 Model Building, but the results shows different numbers than expected.

My models shows: 

hanhuiwu_0-1666644321856.png

It should be: 

hanhuiwu_1-1666644343590.png

It seems like my data import doesn't recognice the right decimals of the numbers that were imported. Anyone having the same issue? How to solve this?

 

The steps I followed during the import:

hanhuiwu_2-1666644410127.png

hanhuiwu_3-1666644418954.pnghanhuiwu_4-1666644424657.png

 

 

 

Tagged:

Comments

  • jagadishdash
    jagadishdash

    @hanhuiwu 

    Before importing the data. Go to blueprint view and edit the line item format.

    line item Format : Number >> under number click decimal places 2.

    Then import or run the action. It'll come.

     

    Hope it's clear.

     

    Thanks,

     

    Jagadish Dash

     

  • hanhuiwu
    hanhuiwu

    @jagadishdash 

     

    Thank you for your reply. This was not the solution.

     

    It tried something else and it solved the issue. While importing I changed the Decimal Separator from 'comma' to 'dot'.

    hanhuiwu_1-1666706119422.png

     

  • jagadishdash
    jagadishdash

    Oh great, as per your formating issue i thought may be you missed in line item formating and didn't noticed it. Anyway go ahead with your learning. 

     

    Thanks, 

     

     

Categories