Forum Discussion

PSRai's avatar
PSRai
Icon for Helper III rankHelper III
6 years ago

Create a automated daily rate

Hi,   Is there a way I can autopopulate figures into each date using a start and end date. Below is a example I need to replicate. I need to create a daily rate.   Start date           End date  ...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

PSRai ,

 

This is the desired outcome. Each contract has a total rate. I need to divide the total rate by the number of days the contract is live and apply that to each day its live

Your requirement is not so clear. Could you please show the logic expression and give the expected result?

 

Regards,

Jimmy Tao

PSRai's avatar
PSRai
Icon for Helper III rankHelper III
6 years ago

Hi v-yuta-msft 

 

I have the following columns,

Contract No, 

Hire date

End date 

Total Rate

 

Contract No - 00001

Hire date - 01/01/2019

End date - 11/01/2019

Total Rate - 125.73

 

Outcome =  Divide Total Rate and apply by number of days contract is live

 

=125.73/11 = 11:43

 

Output

01/01/2019; 02/01/2019; 03/01/2019; 04/01/2019; 05/01/2019; 06/01/2019; 07/01/2019; 08/01/2019; 09/01/2019; 10/01/2019  

11.43            11.43           11.43            11.43            11.43            11.43           11.43            11.43            11.43            11.43

 

11/01/2019

11.43

 

There are many contracts with different hire dates, end dates and total rates.