Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've got a situation where I've got a few buttons listed as : Team A, Team B, Team C, etc. defined respectively as 1, 2, 3, etc in my variable list.
I would like for this histogram to render the sales based on these teams and I have my syntax as follow.
=if(($(vTeam)= 1, [Days in Team A]), if($(vTeam) = 2, [Days in Team B]), if($(vTeam) = 3, [Days in Team C]))
I have done it this syntax by just one team and it works fine. Once I incorporate the other 3 if statements to render the chart it doesn't read it properly. Can someone please guide me on what I am doing incorrectly here. Thank you.
Awesome! I was able to get the nested ifs to work as well as the solution you provided!