Skip to Content

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 (63.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 07, 2015 at 11:15 AM

    Hi,

    try the below option check the result output

    create the new formula -> put theĀ  count (33 kv) -> hit the aggregation tab -> select the exception aggregation -> select summaiton/total -> use the reference char -> contract account.-> save it.

    then execute report in RSRT

    check the output results.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Phani,

      Thanks for the response. I tried creating the steps suggested by you.

      1. Created Formula variable on Voltage (i.e., 33KV )

      2. Created New formula with Count (Voltage)

      3. Aggregation as Summation with Ref char as Contract Account

      But still couldnot achieve the desired result as the Count column is giving 1 to each contract number irrespective of whether already availbe or not.

      Regards,

      Dinkar

  • Jun 08, 2015 at 09:49 AM

    Hi,

    Are you only going to use that combinations of characteristics?

    Check this document if this might help you:

    How to get unique count of values in one (1) or more characteristics

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded