Bex Query : calculate CKF per record
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.
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.