SUM IF Anaplan

Options
HugoManchon
HugoManchon
in Modeling

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):

Screenshot 2023-06-07 094421.png


my "base" P&L looks like that:

image.png


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

image.png


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,

Answers

  • Misbah
    Misbah
    Options

    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

Categories