I was able to import the details without any error messages and I have progressed through to lesson 11. I just have one question about the module that I see. Why is the Dept Code in full such as 'Sales' and why is the country code in full such as 'Canada'. If it is the code shouldn't that column have only codes? Or is it because we have set the format to E1 Department and G2 Country? Screen shots of both views attached. Regards Thiru
I have now changed the name. However, I am unable to work out what Headcount formula is all about. I have attached a screenshot of the formula and have difficulty trying to understand this formula. How can the sum function apply to country? I would appreciate some help.
Since Country line item is a list formatted line item , Headcount is being summed according to Country in the particular formula .
Headcount summed up by country .
Another condition here they are checking is whether it is Actual or Forecast.
For DATA01 P&L Actuals & Budget" module country is one of the dimension . Thats y summing up is not required as it gets summed up before coming to Rep 03 module . only for the forecast value we need to take it from "EMP 02---" module where sum is needed .
For Forecast get the headcount from EMP02 module and aggregate the heacount by country.- See below this formula will aggregate the headcount based on country and US in your current module will show 3 and Canada 1
and For Other Version get the headcount from DAT01 Module as is
Thanks for the response. I did not copy the formula. I opened the calculation tab and added the formula by opening each specific module and clicking on the row headers and column headers so that I could avoid any typos. I will check the modules and see if they are in the same order. My understanding is that you need not have the dimensions in the same order. Which means a module which has a 'Headcount' row can be used in the formula to get a result for a 'Headcount' column in the result module? May be I am wrong. Thanks Thiru