Share
ReportHello,
I have been learning forecaster on my own by trial and error for the past week. I managed to get far but I stumbled into a wall yesterday.
SCENARIO: The users for the sales department need to enter the budgeted units to be sold by product. The users for other departments will enter their regular budget information in currency. As a result I have setup various input sheets for the multi row tab based on the department selected by the user. Hence the finance department will get a listing of accounts to enter the budget and the sales department will get a listin of products to enter the budget. (I included the products in the main account segment so they can be added as lines to the input sheet so the values are being saved). All this was done because the revenue lines or units cannot help me. This solution seemed to meet the requirements however I am unable to get the units entered in the product row for the sales division to update the sales account on another input sheet.
QUESTION: Is there a special calculation I need to use to get the sum of the products to add to the sales account?
SAMPLES:
TOTAL='2100:'2240 (this is a line calulation on the input sheet of the multi row tab the sales people will have. This formula works fine.
'4000=TOTAL (this is a line calculation on the input sheet of the multi row tab the other departments will have) 4000 is the sales account. I am not getting this formula to work.
Please help!
Regards,
Rennecia
*This post is locked for comments
All responses (
Answers (
291,253
