Results to be used in another calculation field.

[Former Member]

Dear All,

I have a report showing average month in unit wise. The result is aggregated for "total" average month. Now I want to use that value, total result value in a formula variable for calculation. i want to create another calculation based on result which i have got in average month field.

Average Month field is CKF.

Example:

Technical id number AVGMonths MONTH

'9185 1

'9185 3

'9185 4

'9185 2

Overall result is 10

I need overall result 10 to be displayerd in MONTH field.

Please help me to overcome from this problem.

Regards,

MohammeD.

Edited by: mohammed marika on Feb 14, 2011 9:48 AM

[anshu_lilhori · Accepted solution]

Hi,

Make a new formula for your field 3 ie months and in that formula use data function SUMCT

And put you calculated keyfigure LIke this SUMCT(avg months)

Just give a try to this solution.Hope it serves your purpose.

Regards,

AL

[Former Member · Accepted solution]

Hi,

Thanks For your reply,I have tried but it doent work.

Regards,

MohammeD

[anshu_lilhori · Accepted solution]

Hi,

It seems it has some limitation when we use SUMCT function with CKF.

Please check the below thread for the same

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/007ba7a0-bcea-2b10-7e89-cbcb9db98...

Try using SUMGT function also.

Hope it helps you.

Regards,

AL

Edited by: AL1112 on Feb 14, 2011 10:44 AM

[Former Member · Accepted solution]

Make avgmonths as global CKF ( which is be defined on left panel of query designer.

create sumct of ( global ckf)

It should work.

[Former Member · Accepted solution]

Hi,

I have got an error message formula operation "SUMCT" is not allowed here..please suggest some other alternative solution.

Regards,

MohammeD.

[Former Member · Accepted solution]

let me elaborate it

Make avgmonths as global CKF ( which is be defined on left panel of query designer.

then drag drop to your columns from CKF folder of query designer

create a new formula

sumct of ( global ckf ) which you drag dropped earlier.

it is working for me..

[Former Member · Accepted solution]

Hi,

I tried the samesteps as suggested .But i have got the result as NONE in all field.

Result

Technical id number AVGMonths MONTH

'9185 1 NONE

'9185 3 NONE

'9185 4 NONE

'9185 2 NONE

Regards,

MohammeD.

[anshu_lilhori · Accepted solution]

Hi,

Try running the query iN RSRT

[Former Member · Accepted solution]

Hi,

Faced same result in RSRT .

MohammeD.

[Former Member · Accepted solution]

let us check whether your version of sap supports sumct function or not...

create a sample kf with constant 1.

create CKF 2 with sumct ( kf1).

check the result . if not then you need to apply OSS note..

[Former Member · Accepted solution]

Hi,

I tried for different KF..its working fine ..But not my calculated result

Edited by: mohammed marika on Feb 14, 2011 1:40 PM