Problem in SubTotal in straight table

[#1]

Dear Experts,

There is problem with subtotal in a straight table as shown in below table.

The last column expression does not evaluate subtotal for column F2.

Please help us to get correct result for subtotal.

Please refer attached file.

Regards

Nitin K

F1	F2	=SUM(F3+ (F4/F5) )	=SUM(F5)	=SUM((F3+ (F4/F5) ) * F5)	= SUM((F3+ (F4/F5) ) * F5) / SUM((F3+F4)*F5)
A	1.1	2.75	4	11.00	0.55
A	1.2	3.80	5	19.00	0.54
A	1.3	4.83	6	29.00	0.54
A	Total	11.38	15	59.00	0.54
B	1.1	2.75	4	11.00	0.55
B	1.3	4.83	6	29.00	0.54
B	Total	7.58	10	40.00	0.54
C	1.1	2.75	4	11.00	0.55
C	1.2	3.80	5	19.00	0.54
C	1.3	4.83	6	29.00	0.54
C	1.4	5.86	7	41.00	0.53
C	Total	17.24	22	100.00	0.54
D	1.2	3.80	5	19.00	0.54
D	1.4	5.86	7	41.00	0.53
D	Total	9.66	12	60.00	0.54

[robert_mika · Accepted solution]

Try this:

= SUM(((F3+ (F4/F5) ) * F5) / ((F3+F4)*F5))

[alexandros17]

Your last expression should be:

= SUM((F3+ (F4/F5) ) * F5 / ((F3+F4)*F5))

let me know

[#4]

Thanks Robert,

Its working

[#5]

Thanks Alessandro,

Its working

[#6]

Dear Robert,

I'm colleague of Nitin, We're evaluating below expression. Could you help to reorganize the equation.

=sum(if(MDC_YEARMONTH_PS >= v_PRE_VER_YEARMONTH and MDC_VERSN_PS = vPrestart_Version and MDC_TYPPS_PS = 'M', MDC_PLAN_VAL_PS + (MDC_PLAN_VAL_PS * v_CONSUM_NORM_PRE)))

/sum({<TO_YEARMONTH={'>=$(v_PRE_VER_YEARMONTH)'},TO_VSNMR={$(vPrestart_Version)}>}TO_FC_QTY)

Thanks

Ashif

[robert_mika]

You are welcome.

Could you mark the answers as Correct ,please?

[robert_mika]

This is more tricky.

Could you post your file?

[#9]

File is more than 300MB. So could not possible. Thats why Nitin created sample file.

[robert_mika]

Sorry Ashif.

This is a little bit too complicated for me yet.

Maybe Allesandro will help