- SAP Managed Tags:
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
| User | Count |
|---|---|
| 11 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.