AnsweredAssumed Answered

Calculations based on text color

Question asked by MikeProcopio on Apr 7, 2012
Latest reply on Apr 9, 2012 by philmodjunk

Title

Calculations based on text color

Post

I am wondering if there is a way to set a calculation to get the sum of fields, but not to include numbers that are a certain color. On my database below I have player salaries that I have a calculation that adds up total player salary. On some contracts there is a qualifying offer listed in a certain color. THe qualifying offer is not part of the contract, but an estimation and I dont need it in the calculation. As you can see I set it a certain color. Not every player has a qualifying offer. Is there a way not to include the qualifying offer in a calculation??

Screen_Shot_2012-04-07_at_9.09.25_AM.png

Outcomes