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.
@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.
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,
this is the default function
if you write round(lineitem,0,up) it will always round to next highest value as seen which will match with the data check
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"