Design Reports - How many days ago the last sales order was created

[clovismuller]

Hello Design Reports Experts!!

I would like to create an index (Key Figure) to display how many days ago the last sales order was created for the customer via Key Figure in a report.
The idea would be to first perform a filter to list only the last sales order created for the customer, and then use the “created on” field of the sales order to perform the calculation.

Example image:
Customer placed the last order on 12/3/2024.
Today's date: 12/5/2024
Expected result in a given Key Figure: 2 days
Idea of ​​calculation to be performed: 12/5/2024 - 12/3/2024 = difference of 2 days.

Thanks a lot for the help.

Clóvis Müller

[ShuvaSamal]

Hi

I had a similar requirement to calculate the difference between two different dates. Unfortunately, it cannot be done using standard key figures. I raised an incident with SAP, and they confirmed that it is not possible due to a limitation in their product. However, you can achieve this by using the delta function.

[clovismuller]

Hi, thanks for replay. When you talk about "Delta function", are you talking about Key Figure with in Data tab > Delta function? Or is it something related to SDK?