Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How Calc percent in matrix column?

Status
Not open for further replies.

liorlankril

Programmer
Nov 5, 2005
46
IL
I have a SQL report that contain matrix. One of it's Column Group contain SubTotal column . If I get on the Dynamic Column Group results 2 columns that Data values are 5 and 3, I get in the SubTotal column only 8 (I add the operation SUM in the expresion of the Column Group.
Now I want to add column the it's value is the precent of 5 from 8. (5 is the value in the first column and 8 is the SubTotal) How to do this???
What should be the expresion?

In fact I nees to write expresion that operate )Column group value/Subtotal)

How can I do it???
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top