Key Figure Error: Aggregation & Assignment are NOT performed in a single step

[Former Member]

Hello Team,

Apologies if its a lame question

I wrote a simple calculation on a helper key figure

" HcostAlert@DAYPRODLOCSRC = Avg(UnitCost@DAYPRODLOCSRC) "

Whereas this unit cost is a calculated key figure which is a simple division between Total production cost/production receipts.

Intention is to use this helper key figure of averaged unit price production across locations, and if Unit price for any given Location > Average unit price across location...throw an alert.

But getting struck with the below error.

E - In calculation 153129822 | HCOSTALERT@DAYPRODLOCSRC, aggregation and assignment are performed in a single step. Split it into two.

Whats wrong with this simple one line calculation

" HcostAlert@DAYPRODLOCSRC = Avg(UnitCost@DAYPRODLOCSRC) "

As its a helper KF, we dont have a request level. So how to split this and achieve the unit price comparision

Please help

[Former Member · Accepted solution]

Hi Venkat,

You can try following calculation.

Average unit price = Avg(HcostAlert@DAYPRODLOCSRC)

HcostAlert@DAYPRODLOCSRC = UnitCost@DAYPRODLOCSRC

[former_member654033]

Hi Venkat,

Write your syntax in 2 steps.

First aggregate value to required planning level

Then do the assignment to another key figure.