I have 2 rows in my matrix which are a result of a dataset. I'd like to
determine the percentage of the two within the subtotal row. Let's say I
have one row called "Lates" and another called "Line Items". How can I get
the subtotal column to display the result of "Lates/Line Items" instead of
the total of the two?Here is some more information - any help would be great as I need this solved
as soon as possible.
01/05 02/05 03/05 04/05 05/05
06/05
Lates 1 2 0 4
1 3
Line Items 555 458 360 675 456
789
%On Time 99.82% 99.56% 100% 99.41% 99.78% 99.62%
The %On Time row needs to be calculated like 1-(Lates/Line Items). I've
spent the last 10 hours trying to solve this problem with no success. I'm
attempting to do this within a matrix.
"yrmeyer" wrote:
> I have 2 rows in my matrix which are a result of a dataset. I'd like to
> determine the percentage of the two within the subtotal row. Let's say I
> have one row called "Lates" and another called "Line Items". How can I get
> the subtotal column to display the result of "Lates/Line Items" instead of
> the total of the two?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment