Counter Key Figure

[Former Member]

Hi All,

I have a scenario where I need to <b>count the number of records</b> in the InfoCube data with one particular characteristic value (e.g. count records where CLEARING_AREA = 'CLRAR'). I have defined a key figure, which would always hold the value of 1. This constant of 1 comes from the Source System and is directly assigned to this KF.

I have defined this KF with Aggregation and Exception Aggregation values as 'Summation' but I guess the <b>type of KF I give is incorrect - with 'Number' and 'Integer', I am unable to do a summation</b> on this KF in the query designer; whereas I notice that with a payment amount KF with type 'Amount', I am able to do a summation in the Query Designer.

I have already <b>referred to an earlier post: , but it doesn't tell anything about the type of the KF to be given.

Request you to please help me out with this.

Thanks and Regards,

Vidya.

[Former Member · Accepted solution]

hi vidya

check this link it may help u how to create a counter

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/7e58e690-0201-0010-fd85-a2f...

regards

abiram

[Former Member]

Hi Olivier..

By 'not able to do summation in the Query Designer', I mean that when I drag the Counter variable into the formula box, those open-close brackets appears to the right of the Counter field: 'Counter'( ). It neither allows me to delete the brackets nor to leave them empty. If I give any value in them, it merely displays that same value in the report; e.g. if I give 2 within the brackets, it merely displays 2 in the report, without any summation.

I could not figure out why those brackets appeared. I deleted the Key Figure and created a new one. Now I am able to do the summation on this new KF without any problems. Those brackets also don't appear for this new KF in the formula box. The mystery remains unsolved...

Thanks and Regards,

Vidya.

[Former Member]

Hi,

weird.. what do you mean exactly by "unable to do a summation in the QDesigner"??

your counter should perfectly work...

let us know...

Olivier.

[Former Member]

Thanks for your reply abi ram.

In the document, in step 5, when I drag that 'Counter' variable into the formula box, it displays two open-close brackets after the KF name, like:

<b>'Counter'( )</b>

If I leave the brackets empty or try to delete them, it gives a syntax error in formula. If I give any value in the brackets, that value is merely displayed on the query result, without any summation.

Does anyone have any clue what these brackets are all about?

Thanks and Regards,

Vidya.