Edit a few lines of code (ASP/VBScript)

$10-30 USD

Completed

Posted

over 8 years ago

$10-30 USD

Paid on delivery

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([login to view URL]("pd_01_gbook_grade"),[login to view URL]("pd_02_gbook_grade"),[login to view URL]("pd_03_gbook_grade"),[login to view URL]("pd_04_gbook_grade"),[login to view URL]("pd_05_gbook_grade"), [login to view URL]("pd_06_gbook_grade"), [login to view URL]("pd_07_gbook_grade"),[login to view URL]("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.

ASP

SQL

Project ID: 8515370

About the project

3 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@marcelorfurtado

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 in 1 day

5.0

(2 reviews)

1.8

3 freelancers are bidding on average $33 USD for this job

@MohsanEijaz

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 factors in your project.

$13 USD in 1 day