SAP PRT counter during production order confirmation

[alex_alex85]

Hi,

My business scenario:

we have PRT which we should use during production order confirmation. And the requirement is to track how many times this PRT was used. So if I confirmed Production order 3 times, than counter should be equal to 3.

.

I have created equipment (PRT), measuring point etc. And in certain way it works.

Initial formula for Counter is YSAP02 = SAP_09 Operation quantity

So in this case it works fine:

Confirmation1 Yield = 200, than Counter = 200

Confirmation2 Yield = 300, than Counter = 200 + 300 = 500

So in this case it looks good

----------------------------------------------------

Now I wanted to adjust my formula for my business case.

My new formula is "SAP_09 / SAP_09". So when I confirm Production order my expectation is to have Counter always equal to 1 adding to previous counter value.

Example:

Confirmation1 Yield = 200, than Counter = 200 / 200 = 1

Confirmation2 Yield = 300, than Counter = 500 / 500 + 1 = 2

But in this case with new formula every measurement document is created with Counter = 0.

So there are questions:

1. Are there other ways to calculate how many times PRT was used?

2. Not clear why adjusted formula calculated as 0 instead of 1.

Thank you.