Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Try this:
= SUM(((F3+ (F4/F5) ) * F5) / ((F3+F4)*F5))
Your last expression should be:
= SUM((F3+ (F4/F5) ) * F5 / ((F3+F4)*F5))
let me know
Thanks Robert,
Its working
Thanks Alessandro,
Its working
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
You are welcome.
Could you mark the answers as Correct ,please?
This is more tricky.
Could you post your file?
File is more than 300MB. So could not possible. Thats why Nitin created sample file.
Sorry Ashif.
This is a little bit too complicated for me yet.
Maybe Allesandro will help