Register
Ask the Community

About GaryPage

since ‎05-30-2019
‎10-21-2020
GaryPage
Occasional Contributor

Next step after completing the old 102 course?

by Occasional Contributor in Academy & Training
‎09-05-2019 01:36 PM
‎09-05-2019 01:36 PM
I completed the first two courses a couple of month ago. The new course was announced pretty much as I was finishing.   What is the logical next step from there. For background I am a (very?) experienced excel modeller and architect, and want to ultimately be able to design a solution from the ground up. Happy to do that in baby steps. ... View more
Labels:

Best practice for 'Corkscrew accounts'

by Occasional Contributor in Anaplan Platform
‎07-18-2019 11:10 AM
‎07-18-2019 11:10 AM
Hi,   What is the best practice way to do a classic brought forward / movements / carried forward calculation? Using OFFSET in the brought forward formula to capture the previous period? Or is there a better way?   TIA ... View more
Labels:

Re: Two dimensions where not all cross joined comb...

by Occasional Contributor in Anaplan Platform
‎06-22-2019 08:12 AM
‎06-22-2019 08:12 AM
@rob_marshall @LipChean_Soh Thanks both.  I can see how this approach will let me get a hierarchy will only have the required items, and that the numbered list with display names will get around the duplication of names. I am not sure how this will allow me to show a breakdown of sales by product. Even though the products will have the same name, they won't really be the same under the hood will they?   I haven't looked at the 305 training yet, but I will do. ... View more

Two dimensions where not all cross joined combinat...

by Occasional Contributor in Anaplan Platform
‎06-21-2019 03:17 PM
‎06-21-2019 03:17 PM
Hi   i have a list of divisions and a list of products. The divisions are defined by customer type and not by product, so not all divisions sell all products, but there is a lot of overlap. We would want to be able to show sales by division, and also sales by product.   The easy thing would be to have two unrelated lists, but the issue with that is the vast majority of combinations will always be blank. Also a division FC would want to see only those products relevant for his division, and not some giant list.   Illustrative example is below, but there would be a lot more “missing” products.   Division A     Product W     Product X     Product Y   Division B     Product X     Product Z   Division C     Product X     Product Y     Product Z   Any suggestions? TIA ... View more
Kudos given to