Can I use a WHERE clause in dimension as report filter?
Mar 21, 2018 at 04:42 PM|24 Views
I am creating a report that includes many tables, one of them needs to show records that have not been modified in the past 90 days, I would like to use the following formula but It turns the field to null instead of hide it and adding a not null filter does not work neither. =[Opportunity] Where ([LastUpdate]<RelativeDate(CurrentDate();-90)) A normal filter with a static date works but I want to use a relative date so I do not need to change it every day. I notice that the problem start when I add fields like region or dates to the table, but I do need them. I have other fields in the table that do not affect the results.
Add comment