Skip to Content

IBP - Local Member Configuration

I am trying to create a Local Member to do inventory projections.

row 3 - has a local member I have named L BOH. The config I would like to work is

'=IF ( ISNULL ( 'SystemInventory" ) , PreviousMonth 'L EOH', 'SystemInventory')

so the calculation for C3 would be = IF ( ISNULL ( "C3" ), "B17" , "C3")

People will not be modifying the template once it is created, so I can use hard coded cell references if needed.

I am sure this is possible, but outside my wheelhouse - any assistance would be appreciated.

Thanks,

dan

localmembercalc.jpg (234.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 20, 2018 at 07:21 AM

    Please show screenshot of local member setup you have tested!

    Add comment
    10|10000 characters needed characters exceeded