Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Bex Query : calculate CKF per record

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

Not what you were looking for? View more on this topic or Ask a question