Discussions

Expand all | Collapse all

Create a dynamic change rule for numeric formula field

  • 1.  Create a dynamic change rule for numeric formula field

    Posted 08-03-2017 15:10
    I am trying to create a dynamic rule that changes a numeric formula field to "0" if an option is chosen in a drop down field. However the numeric formula fields seem to disappear when trying to pick a 'change' command. Any options for workaround?


  • 2.  RE: Create a dynamic change rule for numeric formula field

    Posted 08-03-2017 15:28
    You cannot manually edit the result of a formula numeric field either by hand editing or a form rule.  You would need to have an override field or check a box and then change your formula to use that other field in its calculation


  • 3.  RE: Create a dynamic change rule for numeric formula field

    Posted 08-03-2017 15:37
    Thanks! That idea worked!