SUMCT function

[Former Member]

Hi Experts,

Any insight into use of 'SUMCT' function. Right now we are using to move result of a column to another column. Any other known utility for this function.

I appreciate any further insight for this function.

regards,

Varun.

[Former Member]

Hello Varun,

Here is information for SUMCT, Go through Anil's link for more information.

SUMCT <Operand>

Delivers the result of the operands to all rows or columns.

e.g.

Year Region Sales SUMCT “Sales”

1999 North 30 60

South 30 60

Result for 1999 60 180

2000 North 60 120

South 60 120

Result for 2000 120 180

Overall Result 180 180

San.

[Former Member]

Varun ,

Please check the links

http://help.sap.com/saphelp_nw04/helpdata/en/e2/16f13a2f160f28e10000000a114084/content.htm

Also Note:

Queries containing formulas with the operators %RT, %CT, %GT, SUMRT, SUMCT, SUMGT, and LEAF cannot be released for OLE DB for OLAP. These operators are dependent on how the list is displayed in the BEx Analyzer and the formulas return unexpected values when using OLE DB for OLAP or MDX.

Hope this helps

-Doodle

Message was edited by: Doodle

[former_member188325]

Hi,

If you want to use Result(Overall) of a column,Use SUMGT frunction.go thru above link referred by anil for detailed info.

Thanks

[Former Member]

Hi,

Have you seen the example given in the help?

http://help.sap.com/saphelp_nw04/helpdata/en/03/17f13a2f160f28e10000000a114084/frameset.htm

With rgds,

Anil Kumar Sharma .P