So in the picture above THe player Taj Gibson has a qualifying offer in 3,178,447 in the year 2013. I want that calculationt o only add up the 2011 and 2012 salries for him because those are guaranteed. But this isnt the same for everyone as players have qualifying offers in different years so I cant set the calcualtion for all to just not add 2013. Is there a way since I have quaifying offer in a certain color to exclude it?? It may not be possible, just taking a shot in the dark
I tought this was an interesting question so I tried to find a solution.
I don't know if it's the best one possible, but here's what I came up with.
You might want to try it out thourroughly before using it.
Make sure the "Filter" contains all the possible color letters.
For those who only want the calculation:
If ( Number = Filter ( Left ( GetAsCSS ( Number ) ; 28 ); "color:#FC0123456789") ; Number ; "")
I'd be inclinded to use a simpler approach. Add a value list formatted field that controls the color via a conditional format. You can then set up a calculation that uses IF or Case to check the value fo the value list formatted field instead of the text color. This makes for simpler code and allows you to tweak the color used without having to also modify your calculation to work with such a new color.