Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
ERROR:Invalid Expression in List
Thanks to the help I got here I have managed to get a number of formulas working on a custom record. Its simple stuff, but I am happy with the results but being the nub that I am, I need some more help.
Here is what the custom record is doing.
The following fields are populated by the user...
[LIST]
[*]{acquisition_date} = date value
[*]{acquisition_cost} = currency value
[*]{lifespan} = positive integer value[/LIST]Based on that info, additional custom fields have the following formulas...
[LIST]
[*]{age} = months_between({today},{acquisition_date})
[*]{monthly_dep} = {acquisition_cost}/{lifespan}
[*]{cummulative_dep} = {age}*{monthly_dep}
0