Is there a way to put in one Formula for Actuals and another Formula for Forcasting? I was thinking I might have to create two Line Items (one for Forecast and one for Actuals) and put those formulas into the separate line items? Is this thinking logic correct?
if isactualversion() then blank else Back Book + Front Book
If it is a date in my Actuals then I want it to be blank (allow me to put in a value), anything else i want it to put in my Forecast Formula. It is saying that my data format doesn't match None or Number.
If you want to have a manual input for Actuals you can use the formula scope option in blueprint view for the line item. Set this to 'All Versions except Actual' and that way your formula will work for all forecast versions but the cells will be blue and editable for the actual version.
You won't need the ISACTUALVERSION() part of the furmula if you do this.