What does the brackets indicate (negatives)? What answer do you expect from
this, a single ratio of the sums, multiple ratios,...?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Eddy" wrote in message
...
I need to measure one set of data over the other. For example, Set A is
forecast and Set B is actuals.
Set A 591 107 (160) (559) (159)
Set B 362 (24) 50 (121) (295)

First pair of data is simple. 362/591= 61%. This means acutals is 61% to
fcst.

Is there a formula to cater to all scenarios above?