J
Jeppe Vejen
Make it an option to have accoPLANNING treat numbers as integers and rounding up/down or down to nearest whole number.
In some cases when you splash a number for something like Quantity you end up with a decimal number in your cell. This isn't always usefull when you want to plan in whole numbers. Especially when using Quantity in a Quant * Price shadow calculation.
As for now accoPLANNING treats a number as a decimal until it hits the database. So if you have 1000 in quantity splashed out over 12 month, you get 83,3333 pr month. Then when calculating Quantity
Price (10 dkk) you get 83,333
10 = 833,33, when you in reality want 83 * 10 = 830.
What is written back to the database is
Qaunt: 83
Price: 10
Amount = 833
because the calculation is done in PowerBI and then the rounding of Quantity happens afterwards.