Forum Discussion

kathod's avatar
kathod
Regular Visitor
7 years ago

Distributing multiple values over different time periods

Hello, I am working with contracts that have a total value and an end date. I want to spread the total value on each working day between today and the end date. So far I calculated the daily value ...
Need Help
kathod's avatar
kathod
Regular Visitor
6 years ago

Sorry for not clarifying this earlier - the contracts are indeed updated daily. So the value of a contract is only showing the open amount that we can expect in the future.

e.g. we do a contract with total value 12k with expiry x. As the time goes by, the customer orders goods that are covered by the contract and each order is reducing the total value of the contract. So after some time the value of the contract is down to 5k for example. Those 5k represent the value that the customer still has to order before expiry.

 

The visualisation is planned like you described it. Having a timeline and showing the distributed values along.

Cmcmahan's avatar
Cmcmahan
Resident Rockstar
6 years ago

So then yeah. I think in that case that the previously proposed solution should work.  Is it giving you bad results?

  • kathod's avatar
    kathod
    Regular Visitor
    6 years ago

    Calculating the daily value of the contracts for the upcoming working days until expiry is working.

    But I still can`t figure out how to distribute these values to future dates.