Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Filter by one column or another

Hi,   I am trying to add a page level filter to my report which is supposed to filter the page by one of two (or both) columns, Documents[StatusID] and Cases[CaseCompletionDate].    I want the fi...
Need Help
mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
7 years ago
Filter = IF(Documents[StatusID] = "6" || Cases[CasesCompletionDate] <> BLANK(), 1, 0)

Asuming that [StatusID] is in text format. then drag the column to page filter and check 1 only