Calculate Key Figure based on 2 dates

[raenoj21]

Hi,

I have 2 attributes Mfd. Date and Expiry Date defined at a batch level.

I want to calculate following values:

1) Shelf Life (Exp. Date - Mfd. Date)

2) Remaining Life (Exp Date - Current Date)

3) Age (Current Date - Mfd. Date)

Is it possible to do this calculation within SAP IBP and maintain the values in a Key Figure.

Additionally, this calculation would need to be done on the fly for 2 and 3 as the current date is changing.

Thanks

[former_member194529]

Hi Raenoj,

Have you found a solution for your requirement? If yes, please feel free to share it here.

Best, Ivan