Skip to Content

Can I use a WHERE clause in dimension as report filter?

Mar 21 at 04:42 PM


avatar image

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.

I appreciate any help

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mar 21 at 04:47 PM

try to create variable with if-else condition.

Show/Hide=if([LastUpdate]<RelativeDate(CurrentDate();-90)) then "Show" else "Hide"

Filter on Show/Hide variable where equal to value "Show"

10 |10000 characters needed characters left characters exceeded