Is it possible to override a formula in a line item? If not, how can I enter a starting amount?
I want to be able to enter a starting amount and from there on have a formula driven on the line item.
Beginning ARR manual enter amount in Apr, then it will drive the calculation to get the ending ARR. The beginning ARR will equal to previous months Ending ARR.
I included several screenshot. The excel file highlighted in yellow is the manual input amount. I was wondering whats the best way to approach this? I know I can just enter a line item to add to the total to make it work.