Hello All, I searched all the resources i knew in order to find an answer to this but, i couldn't find anything, so here goes:
I need a calculated field that does a conditional AVG.
Here's the scenario:
I have 4 fields, with a default value of "N/A"
A=N/A
B=N/A
C=N/A
D=N/A
I need field called AVG that does the average between A,B,C and D. If all fields have values then there is no problem, but if A,B and C have values and D is the default ("N/A") then my average is screwed up.
Any ideas?