Forum Discussion

daxdummy's avatar
daxdummy
Icon for Helper I rankHelper I
5 years ago

Cost Between Start and Finish Dates

Hi I have the data in the folowing format and I'm trying to calculate accrued cost between the dates   If the start date is blank then obviously costs will not accrue, if the start date is populate...
Need Help
Show and Tell
VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
5 years ago

daxdummy 

Between 17/1 and 28/12 the Daily Cost is £5 means total cost you want number of days between these two dates multiplied by 5? and you wanted a cumulative Data right?

daxdummy's avatar
daxdummy
Icon for Helper I rankHelper I
5 years ago

Anyone any input?