Register
Ask the Community

About Andrew_Paston

since ‎03-29-2017
‎01-07-2021
Andrew_Paston
New Contributor
Activity Feed for Andrew_Paston
Group Hubs for Andrew_Paston
View All

Re: Formula Summary type on LOOKUP or OFFSET

by in Anaplan Platform
‎08-04-2019 11:55 PM
‎08-04-2019 11:55 PM
OK thanks....I will give that a try......Appreciate your assistance ... View more

Re: Formula Summary type on LOOKUP or OFFSET

by in Anaplan Platform
‎08-04-2019 11:36 PM
‎08-04-2019 11:36 PM
HI Kevin    Thanks, appreciate you trying to find a solution to this   I still get the error above with that Formula for main and summary for Time. However I think the solution you mentioned would end up aggregating the ARPU metrics into Time period parents....so Jan $50, Feb $50, March $50 Q1 = $150 ARPU which is not correct in the sense of a quarterly ARPU   Perhaps I am doing something silly but our Anaplan solutions architect was also stumped on this.   Thanks Andrew   ... View more

Re: Formula Summary type on LOOKUP or OFFSET

by in Anaplan Platform
‎08-04-2019 11:11 PM
‎08-04-2019 11:11 PM
Hi Kevin   thanks. My understanding is you cant use Formula type summation with a  LOOKUP or OFFSET formula in a line item.    Thanks Andrew   ... View more

Formula Summary type on LOOKUP or OFFSET

by in Anaplan Platform
‎08-04-2019 10:43 PM
‎08-04-2019 10:43 PM
Hi,   We are a NZ Telecommunications company. We have the need to report metrics such as ARPU $ (avg revenue per user) and Avg cost per user across our segments. I can do this compared to our forecasts & budgets easily but if I try to do this for Prior Year or prior period data I am stuck for a solution.    I cant use formula type summation with either a LOOKUP or OFFSET which is needed to look up the prior  period comparison. I have a segment hierarchy and I need it to calculate the ARPU at each level of the list not aggregate so  I need the formula to be used. I have struggled for years on this one but Prior year and prior period reporting has just jumped up in importance    Would appreciate if there was any solution out there or if this could be put forward "Request for Enhancement" to enable these important metrics to be properly calculated.   THanks Andrew         ... View more

Re: RE: Date Formats - Month Name/Text from Date

by in Anaplan Platform
‎02-22-2018 06:14 PM
‎02-22-2018 06:14 PM
Hi John   I know this is very old post but i was interested in this solution and cant find the formulas you mentioned below? Have they dissapeared?   Cheers Andrew ... View more