Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a text object with the following Actions:
Select in Field:
Field: Cases
Search String: Open Calls
Select in Field:
Field: logdate
Search String: =minstring({1<[Cases]-={'Closed Calls'} >} [logdate])
Activate Sheet:
Sheet ID: SH02
This takes me to the next sheet and selected all of the Open Calls where the logdate is the earliest in the list so basically it pulls through the oldest date. (Currently shows a case 741 days old)
However if I select a specific department such as Desktop, the Oldest case show the oldest case in that department, but if I then click on the text object, it still pulls through the case that shows 741 days. Is there a way to change this so it shows the oldest case per department when I click on the text object.
Regards,
Jon Ditchfield
That's probably due to the set identifier 1 you are using in your minstring function.
You can try maybe something like this:
=minstring({1<[Cases]-={'Closed Calls'}, Department = p() >} [logdate])
That's probably due to the set identifier 1 you are using in your minstring function.
You can try maybe something like this:
=minstring({1<[Cases]-={'Closed Calls'}, Department = p() >} [logdate])