Generate rows from calculated fields

[David_Little]

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 !

[IraWatt · Accepted solution]

Hey @David_Little 

Think this achieves what you want:

Let me know if you have any questions or issues :)

HTH,

Ira

[binuacs]

@David_Little One way of doing it

[messi007]

@David_Little,

Please see below :

Attached the workflow,

Regards,

[DataNath]

My solution is just about identical to everyone else's so no point reposting. However, not sure anyone has addressed the rounding. If you want to fix it to 2 d.p. then just wrap your value division in the rounding function:

round([Value]/[No of billing months], 0.01)

[David_Little]

Thanks all !

[IraWatt]

No worries glad it worked for you @David_Little !