AnsweredAssumed Answered

Can I make a calculation that will only add field values >0 in a series of negative, positive, and 0 value numbers?

Question asked by dkdavis on Feb 7, 2019
Latest reply on Feb 7, 2019 by Jason Wood

These 7 fields each have a numeric value of either positive, negative, or 0 value. Right now, I have a calculation that adds all of these fields, but I only want it to add the values that are greater than 0. I am not sure of how to write the "If"

 

current formula

Eng Needed + Math Needed + Science Needed + Soc Sci Needed + FaFl Needed + P E Needed + I S Elect Needed

 

not sure if this is correct or how to finish

If (Eng Needed > 0 & Math Needed > 0 & Science Needed > 0 & Soc Sci Needed > 0 & FaFl Needed > 0 & P E Needed > 0 & I S Elect Needed > 0; add

Outcomes