Thanks for sharing.

I try to replicate the table and column with this query, but it is not working. I am sharing the table and column below. Table - Pay_Run_Balances Column - Balance_Value Could you please write it for me using this table. Thanks.

Hi @MandeepGupta Thanks for the response Not all the employees have 80 hours some of them have 72 and 64 hours. Based on the hours I need to split the values. For Example: if the value is 80 hours, I need to populate 8 hrs/day as 10 separate rows. If the value is 72 hours it should populate 8 hrs/day as 9 separate rows

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

@MandeepGupta Thanks for the response. It was a BIP report, I am trying pull the data of entry hours for the salaried employee hours from the state 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.