Question
HSBC
IN
Last activity: 12 Mar 2019 15:53 EDT
In list view Export to Excel format we need to get value of different property and current property.
We have a requirement as case aging
Case aging should be calculated as difference between WO Create date time and current date time in days.
If WO is resolved then difference between Resolved Time and current date time in days
If WO is resolved and reopened then difference between Reopen time and current time in days.
We could able to achieve above requirement using HTML. But when we refer the same HTML rule in ExportToExcel it always considered the property value and showing
***Edited by Moderator Marissa to update SR Details***
Pegasystems Inc.
IN
Hi
First of all, I suggest you to go for out of the box functions that we offer.
Try functions like DifferenceInDays() and pass parameters like pxCreateDate time etc to calculate the age.
Also explore OOTB report definitions like
Hi
First of all, I suggest you to go for out of the box functions that we offer.
Try functions like DifferenceInDays() and pass parameters like pxCreateDate time etc to calculate the age.
Also explore OOTB report definitions like