Hi all,
Just to note. The actual dataset would be thousands of lines, so I'm looking for a dynamic/automated approach.
The basic example below is a billing forecast: I would receive the data for the whole customer billing total and the number of months it will bill, as well as the estimated first billing date.
How would I then go about getting the estimated line item view below: I would need the "value" to be a divisible of the number of months (accounting for rounding to the second decimal), and the "bill date" to be calculated one month (same month day) from the previous date (with the first month being taken from the "first billing date" field.
Many thanks in advance !
