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

en voir plus : vbscript program using asp code notepad, free asp code online address book, asp code gridview, testing asp code backend, asp code access, code play edit mp3, asp code site similar youtube, 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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(0 Commentaires)

4 freelance font 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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% 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 [login to view URL] have 5 years experience WORDPRESS,OPENCART,C#,PHP,JOOMLA,DESIGNING etc Te Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)