Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Sum formula in XL Reporter

Dear all,

When I am using XL reporter, I would like to get the sum of the expanding section in the next row. I've tried =sum(ixref(D12,2)) in D11 cell, but it doens't work.

Please kindly help.

Thank you!



Former Member
Former Member replied

HI Julie,

A simple solution is put the sum under the expanding section first.

Make another cell on top equal to that sum.

In this way, the formular will work.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question