En cours

Edit a few lines of code (ASP/VBScript)

1. AVG of Different Fields - Ignore Null (Eight scores in different columns need to be averaged but to ignore null values). I have them averaged now but when a grade is not entered it counts against the average and i want it ignored.

"<%=(average([url removed, login to view]("pd_01_gbook_grade"),[url removed, login to view]("pd_02_gbook_grade"),[url removed, login to view]("pd_03_gbook_grade"),[url removed, login to view]("pd_04_gbook_grade"),[url removed, login to view]("pd_05_gbook_grade"), [url removed, login to view]("pd_06_gbook_grade"), [url removed, login to view]("pd_07_gbook_grade"),[url removed, login to view]("pd_08_gbook_grade")))


2. Count the number of these fields that are below .6... so if PD_01 = .7, PD_02=.5, PD_03=4, and the rest above .6 or blank it would write 2.

Compétences : ASP, SQL

Voir plus : asp code gridview, testing asp code backend, asp code access, code play edit mp3, asp code, verify asp code, simple asp code

Concernant l'employeur :
( 33 commentaires ) United States

N° du projet : #8515370

Décerné à :


Hello, Working with internet for 10 years and in all that time always used ASP and SQL. I am the right person for this. I am at your disposal for any clarification. Marcelo Furtado

30 $ USD en 1 jour
(0 Commentaires)

4 freelance ont fait une offre moyenne de 31 $ pour ce travail


Hi, Your problem can easily be solved by adding a conditional check on filed and only adding when its null. Lets have a discussion. Regards Ankur

25 $ USD en 1 jour
(1 Commentaire)

I think I am a good fit for this job because I have all the qualities that you are looking for. Experience is the golden factor in this project where you find in me at least 3+ years of working experiences over all the Plus

13 $ USD en 1 jour
(0 Commentaires)

Hello dear, Many Greetings for the day!! I hope you are doing well and this season is going great for you and your business as well.We have 5 years experience WORDPRESS,OPENCART,C#,PHP,JOOMLA,DESIGNING etc Te Plus

55 $ USD en 1 jour
(0 Commentaires)