Forum Discussion
Switch statement with two independent selected values
Hi - I am putting together a PVM analysis that currently compares Year-Over-Year variances for certain products. I want to add an additional selection box (similar to Sales Type in the top right...
Thanks so much for this.
Just curious, would this solution perform better than the nested IF statements? They both give the same answers.
I'd expect them to be about the same but can't say for sure.
The reason I'd consider it has more to do with the fact that nested logic tends to be a bit more difficult to read, in general. I prefer to not be mentally matching parentheses if I don't have to.