Removing % Symbol 1

[Watermelon]

Hi,

I have a function that is calculating GPAs for students in our database. The problem is that it's leaving this percent symbol (%) on the end of the calculation. I tried to use the left function to remove this but I didn't have any luck.

Does anyone have any ideas for how I can remove this?

Here is the code that is calculating the GPA's.

=(Sum([Grade Value]*([TotNumMtgs]-[IsPass]))/Sum(([TotNumMtgs]-[IsPass]))/100)

Thanks,

WM

 

[SteveR77]

If the symbol a label in your report?

How has the data type for the fiend in the report been defined?

How has the field in the report been defined at the table level?

From what you have describe the % symbol has to be coming from how the field has been defined or it is a literal that has been added to the layout of the report.

HTH,

Steve

 

[Watermelon]

Hi,

Thanks for the response. The Grade Value field is defined as a number in the table. The format for the field on the report is a percent. I'm not that familiar with other formats but I tried standard and fixed and they didn't come out correctly

Thanks,

WM

 

[SteveR77]

If you change the format to standard and then divide that value by 100 do you get the proper result for the percentage?



The field's format is what is causing the % size to be added at the end.

HTH,

Steve

 

[Watermelon]

Hi,

Thanks for the response. Do you mean divide by 100 again?

I did try changing the format to standard and I'm getting some strange numbers. For example one student's GPA was 3.57% (this was correct). When I change to standard it comes out .04.

I also tried changing standard and dividing by 100 again and I was getting 0.0.

Not sure if this is what you had in mind.

Thanks,
WM

 

[SteveR77]

When you change the value to standard make sure your decimal places is set to something like four, then you'll need to mulitply those values by 100 to get 3.57.

HTH,

Steve

 

[Watermelon]

Hey Steve,

That worked great. Thanks very much.

WM