I need a query to split the salaried hours as 8 hrs/day from the state of earnings.

Question

Gianni Ceresa · Answer

@SARAORC ,

Please do not double post, it doesn't get you more answers but the opposite. This one is now closed.

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/62115#Comment_62115

Duplicate of below:

Hi, I need a query to split the salaried hours as 8 hrs/day from the state of earnings. — Oracle Analytics

Thanks.

SARAORC · Answer

Hi,

It was a BIP report, I am trying pull the data of entry hours for the salaried employee hours from the statement of earnings page.

So, I need to split the hours eg: if the value is 80 I need to split into 8 hrs/day as 10 separate rows