Skip to Content
0
Former Member
Mar 11, 2010 at 02:02 AM

Reg : SUMCT function

20 Views

Hi,

We have a requirement where we get the data for the actual hrs from the transaction data and planned hrs from master data . In the report we need to show the variance of the actual to planned.

Actual data in Infocube.

Person --- CS --- Act Hrs ---

P1 --- 100 -- 10Hrs

P2 --- 100 -- 5 Hrs

total actual Hrs 15 Hrs.

for a CS, master data we have planned hrs as 40 Hrs. Now in report we need to show planned hrs as .

P1 -- 100 -- 10 --- 10/15 * 40

P2 --- 100 --- 5 -


5/15 * 40

Kindly let me know how this can be achieved.

Thanks,

VSK

Edited by: VSK on Mar 10, 2010 9:02 PM