Sunday, February 19, 2012

How I can calculate the % in the matix's details base on the matix's subtotal?

This is my problem:

Region1 Region2 Total
duration % duration % duration %

call1 10 10 90 90 100 100
call2 10 10 90 90 100 100

How I can calculate the %, I need to know the total duration!
Nobody can help me?

abc_abc

Do the following

Divide each column in the matrix by the row total and multiply by hundred. Dividing by the row total is a matter of scope. If you go to the edit group properties in you row group, you can see the name of your row scope. So simply divide the current row,col value by Sum(fieldname,rowscope). Remeber to change all your results to a string and concatentate them. i.e. row val.ToString() + " " + computed percentage.ToString().

I am assuming, that u have a single matrix.

Umer

|||Yes I have a single matrix, but it doesn't work... I m sure I'm in wrong in something.
The group Total is the same of Region1 and Region2, I used the Subtotal by right-click

I have written this expression in the matrix's detalil
=(Sum(Fields!Duration)/sum(Fields!Duration.Value,"matrix_Region"))*100

but something is wrong.
but I don't understand what!|||Now it works, thanks...
In the group'scope I used the "latest" row-groups before datails.
abc_abc

No comments:

Post a Comment