Forum Discussion
Help to generate a simple table
Hi all I am looking for some assistance please. My team will manually input a start date and a duration. This will show an end date. Simple enough! What i would then like is a table create ext...
Final question - hopefully just as straightforward. Is there then a way to determine a certain % of the overall value being attributed. So at the moment the formular evenly distributes the value over the total months. What if i wanted to say the first month is always £50k, the 2nd month is always £100k, the third is always £200k, the last month is always £100k and then split the remaining value between the remaining duration
See the attached demo. It will only work correctly if the duration is more than 3 months.