Webi report formula question
source link: https://community.sap.com/t5/technology-q-a/webi-report-formula-question/qaq-p/13593956
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Hi All,
Need your help to solve a query.
I have 4 columns in webi report need calculation as below:
Week no. | Total approved OT hrs | Productive Normal OT allowance | OT allowance | Unpaid Overtime Hrs |
week 1 | 20 hrs | 5.5 hrs | 12 | 2.5 |
01-Oct-23 | 3 hrs | 3 | 0 | 0 |
02-Oct-23 | 0 hrs | 0 | 0 | 0 |
03-Oct-23 | 3 hrs | 2.5 | 0.5 | 0 |
04-Oct-23 | 4 hrs | 0 | 4 | 0 |
05-Oct-23 | 2 hrs | 0 | 2 | 0 |
06-Oct-23 | 0 hrs | 0 | 0 | 0 |
07-Oct-23 | 8 hrs | 0 | 5.5 | 2.5 |
5.5 | 12 |
The "Total approved OT hrs" is the 2nd column whose values are coming from Database.
"Productive Normal OT allowance" 3rd column can be maximum 5.5 hrs each week.
"OT allowance" 4th column can be maximum 12 hrs each week.
Unpaid OT hours will have the rest hrs that is sum(The Total approved OT hrs in every week)-12.
Thank you in advance.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK