Generate rows from calculated fields
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 !
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @David_Little
Think this achieves what you want:
Let me know if you have any questions or issues :)
HTH,
Ira
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks all !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No worries glad it worked for you @David_Little !