Level 2 MB Sprint 2: Verify DEM03 Formulas & Summary Methods

Highlighted
Occasional Contributor

Level 2 MB Sprint 2: Verify DEM03 Formulas & Summary Methods

Hi! I was hoping someone could share if I am missing something in this activity: 

Lkishko_0-1589567876210.png

 

and this is what I have in my module: I am having trouble matching the rounded cells and I think it's throwing off the rest of the data. 

Lkishko_1-1589567963712.png

 

Anyone have advice on how to fix this or if I am correct because I don't understand how 59.47 rounds to 60?

 

Thank you ahead of time!

 

 

8 REPLIES 8
Highlighted
Certified Master Anaplanner

Re: Level 2 MB Sprint 2: Verify DEM03 Formulas & Summary Methods

Hi @Lkishko, you will need to modify the formula for the Initial Demand Forecast to ROUND up the default forecast.  In this case you are not wanting to round to the nearest dollar but rather always round up (so the key is that you need to tell the formula to round UP to the next whole numeric value i.e. 0 decimal places).  Below is a link to Anapedia to get some specifics on how you might need to setup the syntax.  

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/ROUND.html

 

Hope that helps to get you started!

Highlighted
Occasional Contributor

Re: Level 2 MB Sprint 2: Verify DEM03 Formulas & Summary Methods

Thanks, @Tiffany.Rice!

I guess it didn't clearly specify to have to round up, instead I just changed the format to 0 decimal places -which made it round to the nearest value. 

 

Thanks for the help!

 

Highlighted
Contributor

Re: Level 2 MB Sprint 2: Verify DEM03 Formulas & Summary Methods

Hello @Tiffany.Rice 

Thanks for you help. I am at the same level of the trainig and i have a format problem in this module.

Instead of having 58.88 for example like @Lkishko , i have 5,887,728... like shown below :

Younes_0-1591189591831.png

Can you tell me how to fix it ?

Thanks

Highlighted
Certified Master Anaplanner

Re: Level 2 MB Sprint 2: Verify DEM03 Formulas & Summary Methods

@Younes
I would recommend double checking the source module for the Baseline Forecast. You likely need to reload the Historic+Volumes.csv into the DAT03 module of the Data Hub (and then run the action to bring that data into your supply chain model). On the File Options within the Import Data Source, ensure the Decimal Separator is set to Dot rather than Comma.

This is not a formatting issue but rather a data issue.
Highlighted
Contributor

Re: Level 2 MB Sprint 2: Verify DEM03 Formulas & Summary Methods

@Tiffany.Rice  Thanks a lot Tiffany, that exactly it. I changed and it works perfectly 🙂 

Highlighted
New Contributor

Re: Level 2 MB Sprint 2: Verify DEM03 Formulas & Summary Methods

Had this issue as well and now it is working fine.

I thought it would be helpful to post a screenshot of the solution. (Decimal separator was defaulting to Comma, and it should be "Dot" under File Options. Thank you @Tiffany.Rice )

 

@bcosta 

DecimalSeparatorDOT.png

 

 

 

Highlighted
Super Contributor

Re: Level 2 MB Sprint 2: Verify DEM03 Formulas & Summary Methods

Hi @Lkishko 

 

By default round function works like normal i.e rounds off to nearest integer if decimal points are 0 but there is a parameter called direction where you can signify whether you want to round the number to next positive integer or lowest integer ,

 

In the example 59.47 , if you use round by default, it will round of to 59 but if you use round with up parameter , it will round to 60, infact any value from 59.01 to 59.99 will go to 60,

Kanishq17_0-1589569678348.png

this is the default function

Kanishq17_1-1589569727240.png

if you write round(lineitem,0,up) it will always round to next highest value as seen which will match with the data check 

 

View https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/ROUND.html to know more about round

 

Highlighted
Certified Master Anaplanner

Re: Level 2 MB Sprint 2: Verify DEM03 Formulas & Summary Methods

@Lkishko 

In financial numbers, it makes sense to round using the default method but these are bars or boxes of chocolate so they can't be 59.5 boxes for the example. That's why you had to round to the nearest whole number.

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"