Sum if on a quarter level line item

GP · 2024-09-09T08:51:55+00:00

There was an error rendering this rich post.

Hey i need a little bit of help,

i want to sum month values to a quarter level value but the dimension isn't really time related its more like converted

The right solution would be 7000 in 'New Quarters Value' on Apr 24. May 24 and Jun 24
actually a simple sum if

The upper Month dimension comes from a list(property) which shows dynamic the next 9 month, so its not a time range in general
List: Financial Plan next 9 Month:

The formula
New Quarters Value: All Adjustments[SUM: Quarter]
leads to an unusal Anaplan error:

Accepted answers

All comments

Sai_Bharadwaj_Venati

You need to create a line item which will be of dimension ⇒ Project, Account structure, Quarter ⇒ In this line item we will use formula of Adjusted values[sum:Quarter]

By using this intermediate line item you can pull value in New Quarter Value ⇒ Intermediate line item[lookup:Quarter]

i tried. this wont works, because the quarters list is also dynamic with the display name.

Values get empty, because of numeric list + no code

FINDITEM('Financial Plan next 4 Quarter', Quarter in Text)

List says: this quarter + the next 3

i also tried to convert the quarter to date so i can make the sum, but this wont work either

adjusted Values[SUM: Date of quarter]

Why is it so hard to build a simple sum if in anaplan - i dont get it

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…