Skip to Content

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

Summing a measure column having break based on another column

Hi,

I have the following sample webI report.

Vendor No.CostStatus
1001000Y
N
N
Y
2002000Y
3002000N
4005000Y

I want to calculate total cost for all vendors having status "Y". In the report break is applied on 'Vendor No.' and 'Cost' Column.

I have used the following formula

=Sum(Cost) In Break where (Status="Y")

But it is giving the total cost as 9000. It is summing up the two rows of "Y" for vendor "100" to 2000 rather than taking only 1000. The correct total cost value will be 8000 ie, '1000' from Vendor No. '100', '2000' from Vendor No.'200' and '5000' from Vendor No.'400'.

Please suggest a formula that will show the correct total cost.

I am using SAP BOXI R3.1 version.

Regards,

Argha

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question