Calculating GP %

(0) Share

Report

Posted on by ShawnBilton2

100

Hello,

I am trying to get a percentage figure for GP by department. I have the departments on their own rows, but it will not do "cal" 160/460 (rows), for example. It just divides the actual number 160 by 460, and I need row 160 divided by row 460.

Can you help? Thanks!

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Calculating GP %

Are you using FRx or Management Reporter? If using FRx, to do a calculation on a row you need to precede the row number with the @ character. For example, to divide row 160 by row 460 you enter @160/@640. If you are using Management Reporter, you do it the same way.