I have radio buttons on a different screen and I'm trying to filter the data as per the selection.
Filter(Purchases, CategoryTxt=thisCat,If(warr="Out of Warranty",DateValue(Expiry_Date)<Today(),If(warr="Under Warranty",DateValue(Expiry_Date)>Today(),false)))
But, the issue I'm facing is, when radio button value is none, I need all items to be shown.
How can I achive this?
Have tried using the switch statement. It could execute different Filters based on the value of the radio buttons. It would look something like this:
Switch(warr, "Out of Warranty", Filter(Purchases, CategoryTxt=thisCat, DateValue(Expiry_Date)<Today() ), "Under Warranty", Filter(Purchases, CategoryTxt=thisCat, DateValue(Expiry_Date)>Today() ), Filter(Purchases, CategoryTxt=thisCat) )
I did this freehand, so there could be some typos.
User | Count |
---|---|
252 | |
107 | |
88 | |
51 | |
44 |