Data entry on if-function with inverse algorithm

BSalveter

Hello,

I have no values in the column HR (Forecast) in some months. I would like to pre-populate these cells with a small number (here, for example, 5) in a new column to enable the cells to be filled by manual data entry. I have used an If function to fill the column: h= if(g=0,5,g). How can I create an inverse algorithm from this function? What would it look like? Nothing has worked so far...

Thanks a lot!

Barbara

Björn Reuber

Hello,

have you tried to use NEXEL (if you are on lowest level) or filling those cells with a DataFlow.

An alternative might also be to not fill them and use pattern based allocation

Regards

Björn