Modifying a field in a report

[cantech2]

I have created a report that works ok. I saved the report with a new name hoping to modift some fields eg.

OLD REPORT has a field called [SALARY]
In NEW REPORT, I want to multiply the value of {SALARY] by 2 or by 50%. What do I do

Thanks,
Cantech2

 

[JesseH]

Declare a text field and define it as = [salary] * 2

Hope it helps.

 

[cantech2]

Dear Jesse, thanks for your response

I was hoping I would avoid creating a new field since the current field is part of a summation formula elsewhere in the report.

Is it possible to apply a formula on the existing field.

Thanks,
Cantech2