Forum Discussion
Using Filter to display only Applications that have end of life workload and are in a migration wave
Hi
We want to display only those Applications listed as Tags that have an EOL = Yes and are within a Wave starting with Wave*. So we can see which applications are migrating that have EOL Machines in the workloads.
This formula doesn't work as expected; it reads but fails to filter by [EOL WL] = Yes
=FILTER(RunBookMS[Tags],(RunBookMS[EOL WL]="Yes")*(RunBookMS[Wave]<>"Wave-1")*(RunBookMS[Wave]<>"Wave-2")*(RunBookMS[Wave]<>"Wave-3"),"")
In the RunbookMS table we want to read the [Tags] column and the [Wave] column and [EOL WL] column is = "Yes" and only display [Tags] names if [EOL WL] = Yes and if [Wave] has Wave* name in the cell. Currently Tags could have names from Wave-1 to Wave-24. Is there any way to do this with a wild card using the * as a wild card?
Can you provide some a formulas?
1 Reply
Your formula works for me:
Is there something else in the wave column of the table besides "Wave-#" maybe?
