count the values in the Report

[Former Member]

hi experts,

I have requirement like i need to count the all the vendors. For caluculations i can use exception aggregation but i created the new selection on vendor for some restictions. now i need to caluculate the this resticted vendor.

how do i count here.

thanks in advance

Regards

amith

[Former Member]

Hi

The above solution needs to be checked when drilled down on free charecteristics

So you must arrive at particular combination of exception aggregation and aggregate reference charecertistics to arrive at the correct results even when you drill down

Regards

N Ganesh

[former_member187400]

Hi Amith,

I suggest you like this ..

You create the info-object (KF) in your info-provider, in the update rules, you store 1 constantly to that info-object.

In the report, you can make RKF for that KF (restricted by vendor). Using this, you can get the count number of it.

Hopefully it can help you a lot amith.

Regards,

Niel

Thanks a lot for any point you choose to assign.

[Former Member]

Hi Amith,

You can use 'Count all values ' as your calculations on vendors.

You will find this in calcualtions tab of the respective KF in the query designer.

This will calculate the total number of vendors even if you have any restrictions on them.