inputable table and calculated column in 1 module

Hi Community,

 

I would like to ask some guidance and idea from you guys. I have an input module:

Problem: How can I keep FY 19 FY20, FY21 and FY22 inputable while FY 23 to DY 26 will be calculated. Is that even possible in 1 module or do I need to publish 2 modules separately to achieve this?

 

Jsdeloria21_0-1635496985520.png

And also for the FY 23 onwards what formula can I use to multiply FY23 to FY26 against the inputted values in FY19 to FY22?

Any suggestion will be greatly appreciated.

Regards,

Best Answer

  • Misbah
    Answer ✓

    @Jsdeloria21 

     

    Line item can either by kept open for inputs or there can be a formula in it.  Anaplan will not allow you to keep certain list items including Time editable and rest others calculated. Although you can block certain items from input thru DCA but the line item will be editable in nature.

     

    Now to answer your question, you will have to create two different lines and write the logic in the second one and keep the first line open for inputs 

     

    Misbah