I have a field that figures an average of two other fields, it works great.
Now I need to add a line above it, telling it to only make the calculation
if both fields are populated. Tried several variations of this:
If(Not(IsNull([Average IBC Avg List Price]) AND Not(IsNull([Average LSI Avg US List Price]),
Average(ToNumber([Average IBC Avg List Price]),ToNumber([Average LSI Avg US List Price]))
All I get is a "parenthesis is missing" error.
Any/all help deeply appreciated,