Calculate count in BEx
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'.