count of no. of records where the quantity field is filled

[Former Member]

Hi Experts,

I have infocube consisting of records.

Please refer to the file attached.

Here in my infocube, not all rows are having its quantity filled.

The quantity is empty for some and is filled for few others.

Now I want to count number of records where the quantity field is filled.

If anyone has come across this requirement or know about this ,then Please guide me the steps ASAP.

Need your help.

Thanks & Regards,

Shruti Yendigeri

[ccc_ccc]

Hi Shruti,

Steps to derive " count number of records where the quantity field is filled"

1. Assuming your required count based on MATERIAL:
2. Do not keep MATERIAL in ROWS
3. Create New calculated key figure and write logic as like below

         General TAB -- > Quantity > 0 * 1

         Aggregation TAB -- > Exception Aggregation --> Summation

                                         Ref. Characteristics --> MATERIAL (you can change, as per requirement)

         Calculation TAB -- > Calculate Result As -- > Summation

1. Drag newly created calculated key figure in COLUMNS
2. And execute report.

Thank you,

Nanda

[RafkeMagic]

two words: exception aggregation