Subtotal , Grand total with Condition on Report

[Former Member]

Hello Experts,

We have a report which displays Acquisition and Budget Values of the projects. There is a condition in report which resticts display of all the projects which has Zero Acquisition value irrespective of Budget values.

When I display Subtotal at Comp code level and Grand total for report, Acq values subtotals and grand total is displayed correctly but not for Budget values. This is due to the condition in the report. There are projects which has Budget values but Zero Acq values. So when subtotals & grand total is calculated system consider those non zero values from Budget too .

e.g. when no condtion on report result is as:-

Project def. CompCod AcqVal. BudgetVal

P1 1001 10 10

p2 1001 0 10

-

---

subtotal 10 20

-

---

Grand total 10 20

e.g. when condtion on report result is on then records are displayed as:-

Project def. CompCod AcqVal. BudgetVal

P1 1001 10 10

-

---

subtotal 10 20

-

---

Grand total 10 20

We need subtotal & grand total for budget to be displayed as 10 not as 20.

How can I achieve this?

Any suggestion will be very helpful.

Edited by: Murtuza Morwala on May 12, 2009 1:04 PM

[Former Member · Accepted solution]

Hi,

Try using : Calculate Result as summation. then totals also effected based on condition.

Check: [Conditons, Calculate Result as......|http://help.sap.com/saphelp_nw04/helpdata/EN/a3/3ea1c929a49741b8e93597f067140c/content.htm]

Srini

[Former Member · Accepted solution]

Hi Srini,

Appreciate it...Thank you .. It solved my issue.

Murtuza.