Modifiers not applying as expected

Question

Hello!

I’m attempting to aggregate my metrics into a full P&L with actual and forecast views.

I have data coming from a Shared_IS_Actuals dimension, several Revenue and COGS dimensions already mapped, a Shared_WF_Plan dimension, and a Shared_Opex_Plan dimension.

I’ve been able thus far to successfully have Actuals for all IS accounts pull in, and have Revenue, COGS, and WF (payroll, benefits, taxes) appear in a single metric.

However, when I try to add my Shared_Opex_Plan data using the formula below, my Actuals stay, my revenue and cogs disappear, my WF_Plan stays, and my Opex_Plan disappears, leaving me with only the WF_Plan.

It’s like the first by modifier to map the WF_Plan to the CoA is applying to everything?

What am I missing?

francois · Accepted Answer

I 100% agree with Nathan, it looks like your Opex and WF metrics do not share the same dimensions.

Here’s a great article that explains what happens when you add two metrics with different dimensions together :

Try to align both metrics using REMOVE, ADD or BY depending on your use case to try and have the result you expect.

Nathan · Answer

Hey Trevor,firstly, you do not need the ( ) around your Metric[modifier], they apply in priority to the metric they are right after.I can’t tell from the formula but it is VERY likely that the 4 parts (the 4 metrics) of the formula do not have the same dimensionality, Pigment doesn’t manage to align manually and you end up with a weird result.