Disaggregation of the value 0

[Former Member]

Dear all,

as you can see in the title, I am facing a problem regarding the disaggregation of the value 0. When I am in BOA and I enter "0" for net sales the average selling price won't change automatically to 0 as well, after the recalculation (I fixed the quantity; ASP = Net Sales / Net Quantity). Especially when I drag new characteristics into the columns, the value is not applied to 0, but still kept in its original form.

Does this refer to any settings within my query? Or do you have any other idea?

Thanks in advance!

Kind regards

Dominik Drebinger

[Former Member]

Hi Dominik,

This is an issue in a number of planning systems where there's no difference between blank and 0. Can you try putting a very small number (e.g 0.000000001) instead of absolute 0 and see if it works?