Forum Discussion

MikeTamoush's avatar
Qrew Commander
3 years ago

Dynamic Filter in Report - tricking it on a formula text?

I might make a formula text field, where say it checks a date and either returns 'Current Month', 'Previous Month', or else left blank.

If I use that formula as a dynamic filter, the  3 choices are exactly that: Current Month, Previous Month, Blank.

Any sneaky way to get rid of the 'blank' option? So they can choose only current month or previous month to filter? I could do an 'ask the user' filter on the date, but I really want it dynamic. I could make my formula text have else be 'all other months'. But would love a sneaky trick to get rid of the blank option.

Mike Tamoush
No RepliesBe the first to reply