Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to create an aged report, using the delivery date as the starting point. So, I'd like the additional movement date field to display as the number of days between that date and the delivery date. Is that possible within the report without displaying the Movement date, or do I need to create a new calculated field within the data manager?
Any help greatly appreciated.
Thanks
SJ
Hi,
You can calculate the difference between dates without displaying the Movement date, add the following as an expression to your chart :
Interval([Movement Date] - [Delivery Date] , 'd')
Data for testing
DATATEST:
LOAD * Inline [
Delivery Date, Movement Date, Name
05/9/2022, 5/10/2022, Order1
05/7/2022, 5/13/2022, Order2
];
Regards,
Vitalii