Skip to Content

Dis-aggregate without decimal

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

1.jpg (27.5 kB)
2.jpg (18.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jul 16, 2020 at 03:50 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.