0 Replies · Latest reply on Apr 21, 2017 4:24 AM by Michelle Kelly

    Suggestion on how to calculate CAPX 5 year view

      Hi all

       

      I have a requirement to auto calculate the CAPX 5 year view and display each year result in the fields yr1 to yr6 if expense type = CAPX.

       

      I have a on change client script currently in place to calculate the total cost. Not sure whats the best way to approach this requirement - After Business rule or onchange Client script.

       

       

      Currently this is calculated in excel and they manually inputted. Everything highlighted in blue is what needs to be entered and everything highlighted in yellow is a calc.

       

       

       

      All suggestion / help really appreciated.