Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Custom calculations in Dynamic Column Groups Expand / Collapse
Author
Message
Posted Thursday, June 17, 2010 9:17 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 02, 2013 10:18 AM
Points: 17, Visits: 326
HI ALL,

I am stuck in a project on custom calculations and need your suggestions. Below is the scenario. I have also attached printscreen of the design and as well as the report.Thanks in advance.

I have a column group based on Sales(sales40%,sales60%,sales 80%) and with Price as detail.I wan to do a custom calculations in (Adjusted Sales) and suppose the calculation is (opp 40%+opp60%/opp80%)/3. How do i perform this? In the design pane it is just one column called "Sales" which on runtime gives me 3 columns(Sales40%,Sales 60%, Opp 80%).


Sales40% Sales 60% Opp 80% Total Total rows (Adjusted Sales)

$500 $1000 $1039 $2539 109 (opp 40%+opp60%/opp80%)/3


Thanks once again.Appreciate your help!


  Post Attachments 
Report.jpeg.png (13 views, 55.33 KB)
Post #939330
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse