Forum Discussion
Solved
Filtering "older than" data
I have a table of inspections. It is summarized to only display the "Latest" inspection date at each Site. I want to filter the table so that I only see the latest inspection if it is ...
Hello,
If I'm not mistaken Inspection is a field within the table so you'll need to have this as a measure.
You can use LastInspection=Max(Inspection)
Then to show only if is greater than 14 days you can use the following measure
LastInspection2=If(INT(Today()-LastInspection)>14,LastInspection)
Hope this helps
gadielsolis
Resolver III
Resolver IIIHello,
If I'm not mistaken Inspection is a field within the table so you'll need to have this as a measure.
You can use LastInspection=Max(Inspection)
Then to show only if is greater than 14 days you can use the following measure
LastInspection2=If(INT(Today()-LastInspection)>14,LastInspection)
Hope this helps
It looks like that works! Thank you so much.
