Pl let me know in which suitaition the Zero values used in DP book

[Former Member]

Hi All,

Pl let me know in which situation/Scenarios the Zero values used
instead of Null/Blank  in DP Planning book,

Regards

kkk

[Former Member · Accepted solution]

Only if you set "zero Allowed" for the key figure in the Planning book.

What then this means is 0 and Blank are treated diffently during disaggregation.

A change at higher level (e.g. Product) may apportion something to an erstwhile "blank" key figure at some level of disaggregation (e.g. when you select Product x Customer) , particularly if there was no data originally recorded/calculated at that level (of Product x Customer). But if "0 allowed" is checked in the planning area and YOU set a value of 0 at this selection level in some cell(s) of this key figure, then this value will always remain zero at that level (Product x Customer) and all granular levels below it (e.g.Product x Customer x Customer's uncle) even after a subsequent change at another (higher) level (e.g. Product or Product Family or Brand or some grouping higher than that).

Hope this is easy for you to visualize now.

Thanks

Guru