Dis-aggregate without decimal

[former_member623786]

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

[Irmi_Kuntze · Accepted solution]

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