Skip to Content

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

Calculate count in BEx

Hi all,

Require your support to achieve the below requirement in BEx.

We have different Contract Accounts wrto each Price Amount and Voltage as shown below. We are asked to calculate the count of contract accounts wrto each price amount and if the Contact account exists already in any of theĀ  price amount, then the same contract number count should become '0' for the preceding Price amount.

Please find the attached sample data and help me achieving the requirement.

As all the contact numbers are already available for price amount 0.0750, the count for 0.0900 should be '0' not '1'.

Regards,

Dinkar

Bex Count.JPG (63728 B)
Not what you were looking for? View more on this topic or Ask a question