How the scenario for New Territories and New Sales representatives are handled?
when there is no previous year data , when the New territories is planned not starting from First month.
What if new sales representatives are planned?
Hi @Rinkesh29 ,Thank you for your request.To me it sounds like you are looking for the "assign"-action.There is an example of countries and employees.In your case you would probably need to replace the parent hierarchy of country with territory.
i have a time settings module dimensioned by time and version. I need to check for months and years in one line item. Is there a formula i can use that will only allow me to tick for months and year and exclude Quarter?
I have created a time settings filter with native version as a dimension. I am suppose to tick true for all the actual months. In Actual version the actual months will be until Aug 20 (because my current period in model calender is Aug 20). A switchover is applied for budget and forecast which is at Feb 20 and Sep 20.…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?