I am having a problem that I think might be a bug, but would be happy to learn otherwise.
Please see this doc -
My desire is to filter the Tasks table based on the [Settings.Effort] value. The problem is that it only works the first 2 or 3 times you change the [Settings.Effort] value, after which it just stops working. If I then change the [Settings.Effort Comparison] value, it “resets” and will work for another 2 or 3 times.
However, if I use the scale control, it works perfectly.
Why not just use the scale control? Well, because this is just a sample doc to illustrate the problem. In the real doc I have 6 aspects that I am filtering on, and doing it in a table keeps it nice and neat -
I have everything working great, except for the “Effort” filter.
Is it a problem in the formula, or a bug? Note, I have tried many variations on the formula, such as with /without .First(), with/without thisRow etc.
Any help would be greatly appreciated.