rob_marshall 
-
Re: SUM & LOOKUP
@CommunityMember111277 In another module, dimensionalized by Region, do your cost sum. Then, if you need the totals for that region, you can do lookups using a list formatted line item (Region). Rob2 -
Re: Calculate the number of complete months between two dates (Similar to Excel DATEDIF Function)
@sosunkwo Give this is shot... Create a module (Start/End Month) that is dimensionalized by what you are trying to figure out, I used Row Count but this could very well be Invoice ID or SKU. Line ite…2 -
Re: Find Highest value
@Kiran96 While your solution works, I wouldn't advise it because you are hardcoding to a certain time member. What happens when the model rolls to another year? The proper solution would be to u…2 -
Re: To get Boolean true after every 2 or 3 months
@aishabhy05 Give this a shot. In a SYS Time module, create a boolean line item with this formula: LAG(1, 1, 0, STRICT) = 0 OR MOVINGSUM('Every 3rd month', -3, -3) Rob2 -
Re: Script to Automate Current Date Import
If you don't have access to a RDMS like Mike referred to in the above, this is a way to do it through Anaplan Connect (shell script style). #Variable for file that gets updated with today's…4
