Calculation on Report

  • Thread starter Thread starter Bart
  • Start date Start date
B

Bart

I have below output in subform

Status Total Beyond SLA Within SLA
Closed 45 12 33
Resolved 5 1 4

I want to compute for the following rate using below formula
Rate(Beyond SLA)= Beyond SLA/(Closed+Resolved)
Rate=12/(45+5)

Rate(Within SLA)=Within SLA/(Closed+Resolved)
Rate=33/(45+5)

How would I do this?
 
Hi Bart,

Each of the values on your report exists in a control (most likely a text
box).
Taking the "Closed" items as an example: There will be three text boxes.
One contains the value "45"; one contains the value "12" and one contains
the value "33". Each of those textboxes have names. Let's say that the
first
one is "txtTotalClosed", the second is "txtBeySLA" and the last is
"txtWInSLA".

You can then create formulae in the fashion of
X= txtBeySLA + txtWInSLA
To get that value to appear in another control you would set the source of
the
other control to "= txtBeySLA + txtWInSLA"
That's not a value you are trying to solve for but you get the idea.

Unfortunately you will likely find that the test boxes have innocuous names
like
text21 and text33 but the same process works.

Regards

Kevin
 
Back
Top