cumulate values

[OliverA41]

Hello,

We want work with cumulative values.

First we cumulate the values of the capacity usage in the new KF "KUMSUPPLY"

• "KUMSUPPLY@WKRESPRODLOCSRC = IBP_CAGGR("NEWCAP2@WKRESPRODLOCSRC", ''SUM'' , ''FORWARD'' , ''PASTCURRENTFUTURE'')"

in the next step, the respective week value will be charged with an MAX Capazity Value. This happened in the KF "WERKZEUGUTILIZATION"

• WERKZEUGUTILIZATION@WKRESPRODLOCSRC = "WERKZEUGCAP@WKRESPRODLOCSRC"-"KUMSUPPLY@WKRESPRODLOCSRC"

During this operation, in one special periode, the value in the KF WERKZEUGUTILIZATION is < 0. in this period, the value of the KF KUMSUPPLY should be changed in 0.

How can I do this?

I attached a screen shot . you see, that in period TW11 the value is < 0. (yellow box). If this the reason, the value in the blue box should change in 0 or 1.000

How can I do this

Regards

Oliver

[piyush_parekh · Accepted solution]

Hi Oliver,

Do you want to replace the number in blue box by 0 and use it further in cumulative aggregation so that KUMSUPPLY in TW12 2020 will be (0+1000) = 1000 and so on? Or are you only looking to replace it with 0 and retain same values in rest of the periods (KUMSUPPLY in TTW12 2020 will still remain 26,941)?

Regards,

Piyush

[OliverA41]

yes the first process is correct.Do you want to replace the number in blue box by 0 and use it further in cumulative aggregation so that KUMSUPPLY in TW12 2020 will be (0+1000) = 1000 and so on