Override and Edit

AbhishekChatterjee14
AbhishekChatterjee14
in Modeling

AbhishekChatterjee14_0-1651242856868.png

I want the Override Sales Target line item to be editable for input when Override boolean Line Item is checked (i.e. true) for the same row otherwise it should be all 0.

Tagged:

Answers

  • ManjunathKN
    ManjunathKN

    Hi @AbhishekChatterjee14 

    you can apply DCA on "override sales target" on write column in blueprint. you need to select override boolean in write column.

    Thanks,
    Manjunath

  • david.savarin
    david.savarin

    You can have the same line item being editable or 0 based on a condition.

    To solve this you need to build a 3d line item "final sales target" which has a formula like if override then override sales target else 0

     

    additionnally to make "override sales target" editable conditionnally, use dca write on it using your "override" boolean line item as the dca write driver

Categories