Help with Expressions in Paginated Reports that refer to subtotals already calculated in Group Cols

[Anonymous]

Hi,

In a paginated report, how could one write a calculated expression (column) that performs the following calculation D / (P - F) at detailed and every Group level?  We can not simply sum the calculations from detailed rows, as shown below.  Thank you

	D	I	P	F	Summed to Parent	Calc at Parent=D/(P-F)
Row Group
Level_1	=Sum(Fields!D.Value)	=Sum(Fields!I.Value)	=Sum(Fields!P.Value)	=Sum(Fields!F.Value)
Level_2	=Sum(Fields!D.Value)	=Sum(Fields!I.Value)	=Sum(Fields!P.Value)	=Sum(Fields!F.Value)
Level_3	=Sum(Fields!D.Value)	=Sum(Fields!I.Value)	=Sum(Fields!P.Value)	=Sum(Fields!F.Value)
Level_4	150	65	240	35	4.143	0.732
Level_5.1	110	35	160	25	3.143	0.815
Employee A	10	20	40	10	0.333	0.333	=D/(P-F)
Employee B	40	0	40	0	1.000	1.000	=D/(P-F)
Employee C	20	10	40	10	0.667	0.667	=D/(P-F)
Employee D	40	5	40	5	1.143	1.143	=D/(P-F)
Level_5.2	40	30	80	10	1.000	0.571
Employee E	0	30	40	10	0.000	0.000	=D/(P-F)
Employee F	40	0	40	0	1.000	1.000	=D/(P-F)

[Anonymous · Accepted solution]

HI @Anonymous,

I think these expression should be modify to aggregate field values based on current level category fields context values:

=IIf(Fields!Revenue.Value > 10000, Sum(Fields!Sales.Value), Nothing)

reporting services - Get previous,current and Next Record in ssrs report in a page - Stack Overflow

Regards,

Xiaoxin Sheng