Question Re: Dis-aggregate without decimal in Supply Chain Management Q&A

Dis-aggregate without decimal

former_member623786 — Thu, 16 Jul 2020 14:30:10 GMT

Hi Guys,

We have a scenario, where we want to disaggregate a weekly quantity to a daily bucket. For e.g. if we disaggregate the value 5, it will disaggregate it as 0.71 for each day. If we round up, the daily quantities is being viewed as 7

Is there a way to disaggregate this 5 into whole numbers? E.g. something like this:

Regards,

Sid

Re: Dis-aggregate without decimal

Irmi_Kuntze — Thu, 16 Jul 2020 15:50:04 GMT

if your key figure is stored, then you can set the decimals in the key figure to 0 and it will round automatically to no decimals. does not work for calculated kf.

this settings with the decimals is used in the web ui for display, is NOT used in Excel, but is used in the rounding