About Jared Dolich

@tompatrickting  Try changing your "Non Blank Rank" formula to this: IF Is Non Blank? THEN RANK(New Order, ASCENDING, SEQUENTIAL, TRUE, Group By) ELSE 1   The problem is that your blank count is exceeding your non-blank count so the max rank is too high. The change in the formula will force the blanks to be a 1 so it can never exceed the non-blanks. As you can see, the change works: ... View more

Hi @debbie5154  @Kanishq17 is correct. Only a workspace admin can change the current period. But there are alternatives. For example,  you could create an input module (or system module) that allows someone to change a line item that simulates the current period. From there you can use formulas that reference this line item to determine the current period. Works great. Candidly, I know a lot of people do it this way because you can also change the line item from outside of Anaplan, like on a scheduler. I know that's not what you want to do, so for now you can just drop that line item on a dashboard and you'll be all set. ... View more

@D0nmac  Sounds great!  Try installing the JSON adapter for SAP data services. https://blogs.sap.com/2012/07/17/jsonadapter-for-data-services-helps-to-bring-unstructured-text-data-into-sap-ecosystem/   ETL standardization is an absolute requirement in my mind, especially if you are trying to automate the imports and exports. You can do this with SAP Data Services but you'll need to be patient and work it out. Anaplan will only send unordered JSON responses. However, the actual file you download can be CSV, text, or Excel format. Just keep in mind that the file will be "chunked" into approx. 12MB each so you'll need to iterate. Again, try reading the API documentation. It's actually really well written. https://help.anaplan.com/anapedia/Content/Data_Integrations/Anaplan_API_Guide.html   Oh, on a side note, I recommend you get a CA certificate. This will save you some trouble with authentication down the road. Here's a good page that provides known Certificates that work with Anaplan. https://help.anaplan.com/anapedia/Content/Administration_and_Security/Tenant_Administration/Security/SupportedRootCACertificatesWithAnaplan.htm ... View more

@CommunityMember119402 (Jay) Great question.  There are a few ways to solve this but I like to use the D.I.S.C.O. Methodology. In this case we will create the following: 1 Transaction module that has your values that you want the standard deviation 2 System modules. One for date and one for quarters 1 Calculation module. This will transform our data at the quarterly level I like to reuse modules that use the same dimensions. Some people don't like that because it can violate the PLANS methodology because it makes it harder to trace the calculations. Up to you but definitely keep your calculations simple. So in this example, I reuse the transaction module to calculate the individual variances.   Start by making sure you transaction module is clean. In this case I created daily sales units for 3 department. Here is our transaction module in it's final state. We will need to add some line items after we've calculated the quarterly values. Transaction module blueprint: Date System Module Used for lookups and filtering. Notice we calculate the quarter period once here. No point in doing this in the transaction module since we have extra dimensions. Date system module blueprint: Quarterly System Module Only created this for filtering. Quarterly Blueprint Calculation module Turn off summary on all line items (not needed) Sum up transactions at quarterly level. Do your calculations here. Very efficient!! Calculation Blueprint ... View more