Account Dimension Formula Column Planning Model

[marija_milutinovic89]

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

[N1kh1l · Accepted solution]

marija_milutinovic89

SAC first attempts to aggregate the data as much as possible, and then processes any calculations. So The calculation parent level, the order is that aggregation happens first and then the calculation, hence you see the large results. You can change this behavior by making the calculation first and then the aggregation at parent node by assigning exception aggregation of SUM to both these calculated accounts. Assign the exception aggregation dimensions as one in the row o your report and also other for which you want the calculation to get aggregated by or just select all dimensions.

Hope this helps !!

Please upvote/accept if this helps you.

Nikhil

[marija_milutinovic89 · Accepted solution]

Hi nikhil_1486,

Thank you for the help and the explanation, it worked!

BR,

Marija