I'm Trying to get a field called "Percentage Improvement" to calculate percentage based on a total annual improvement / an initial test result and then *100

My problem comes because the initial test result is entered via a pull down menu the scoring scale starts out with "Emerging" and then continues 1,2,3...etc.

If the initial test result is "emerging" then I need it to calculate the percentage differently than if the result is a number. I tried to use a case clause to describe the two possibilites, but it keeps telling me that there're too many separators.

Can you help me out? Here's the calculation (I know the field names are long and ugly, sorry)

Case (Benchmark 1 Level Acheived Assessment = "Emerging", Total Annual Improvement*100, Benchmark 1 Level Acheived Assessment > 0, Round((Total Annual Improvement / Benchmark 1 Level Acheived Assessment) * 100),""

Thanks,

Paul

quote:

---

Originally posted by Wildy71:

Can you help me out? Here's the calculation (I know the field names are long and ugly, sorry)

---

I think you pinpointed your problem.

It's a good idea to have descriptive field names, but use "_" or "." to separate words. I think it is common practice to include prefixes and suffixes to let you tell at a glance the field's function and type.

e.g. zk_Record_ID_cn

I also noticed that you are missing the final ")" on your calculation. Those guys travel only in pairs.

[ November 23, 2001: Message edited by: The Bridge ]

You are mixing numbers and text in the field Benchmark 1 Level Acheived Assessment. If you have this field defined as a Number field using "Emerging" will cause problems. Best to define as a Text field and use the following.

Case (Benchmark 1 Level Acheived Assessment = "Emerging", Total Annual Improvement*100, TextToNumber(Benchmark 1 Level Acheived Assessment) > 0, Round((Total Annual Improvement / TextToNumber(Benchmark 1 Level Acheived Assessment)) * 100),""