SUM IF Anaplan

HugoManchon · 2023-06-07T07:53:24+00:00

There was an error rendering this rich post.

hi there,

I would like to build a report which would basically be a P&L where I display the cost per segment in 1 table.

My segments being a grouping of a list (departments):

my "base" P&L looks like that:

and the report I would like to build should look like that:

The idea would be to fill in the cost lines (Human Resources, Contractors and Services, Legal, Consulting and external, Equipment & Office, Software and Other IT and Other costs / Income) of the report to sum them up if they belong to the segment.

What would be the equivalent of a SUMIF formula in Excel?

Cheers,

Accepted answers

All comments

Misbah

Equivalent of SUM IF in Excel is SUM in Anaplan. But I don't think you can use SUM directly. You need to segregate the number in source module by these different departments first. Example, If is HR then data else 0 and then use SUM.

Hope that helps,

Misbah

Miz Logix

Quick Links

Can you help?

Unanswered questions

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…