Bex Query : calculate CKF per record

[tom_darsy]

Hi

i have a requirement to show sicknes cost. Now this calculation has to be sickness hours * Hourly Rate for each employee. I created CKF for this in the bex. the bex is multiplying the total number of hours for all employess into total hourly rate which is wrong.

for e.g

employee          Hourly Rate     Sickness hours

1                              10                    5

2                              20                    10

total sickness cost should be (10*5) + (20*10) = 250

whereas the query is currently doing 30 * 15 = 450.

Any idea what can i do.

Thanks

[RafkeMagic]

in the above example: use exception aggregation on employee

[ccc_ccc]

Hi Tom,

Could you please let me know :

what are objects in rows and columns.

Assuming you have

ROWS

Employee no

COLUMNS

Hourly Rate

Sickness hours

If above case is correct, simply create new formula = hourly rate * sickness hours

Thank you,

Nanda