Dividing in report

[briandrago]

How can I enter the following expression into a report to calculate a percentage, please view the attached report picture

=absolute value((Actuals-FY09 QF2)/(Actuals))

I need to do this for each lane

Thanks for your help

 

[HiTechCoach]

How can I enter the following expression into a report to calculate a percentage, please view the attached report picture

=absolute value((Actuals-FY09 QF2)/(Actuals))

I need to do this for each lane

Thanks for your help

something like:

=ABS(([Actuals]-[FY09 QF2])/([Actuals]))

Assuming that you have the fields [Actuals] and [FY09 QF2] in your report's record source. You may need to substitute [Actuals] and [FY09 QF2] for teh actual field names used by the report's query.