Do you have an S- or P- account?

If so, you need SAP Universal ID. In a few months, SAP Universal ID will be the only option to login to SAP Community. Without it, you will lose your content and badges. If you have multiple accounts, use the Consolidation Tool to merge your content.

Feb 24 at 12:00 PM
# Account Dimension Formula Column Planning Model

Hi everyone,

I wrote some quantity calculation formulas in Account dimension and when I display results in table, on the row level formulas work fine, but I don't want them to be applied on the Total level.

Picture below is formula for QuantityRef:

Picture below is formula for QuantitySim:

As you can see in the picture below, when MarketGrowth total runs through formula with QuantityRef total, I get huge QuantitySim amount. Instead, I want my formulas to be applied only on the row level and not on total level.

Is that possible?

My goal here is to compose value driver tree based on these measures, as you can see in the picture below, right now these amounts are huge because of the multiplying on the total level.

BR,

Marija