Discussions
Using Integer Number in Entity Field to Auto-populate Projections
I am trying to have NetSuite automatically calculate projections for me to accurately forecast our budgets.
I have previously used integer number in fields to calculate the number of years individuals have been volunteering, but unable to figure out how to use the integer number feature to calculate projections.
Field #1 = Ask Amount (currency)
Field #2 = Probability (percent)
Field #3 = Projected Amount
The formula I am currently using for projected amount is: (custentity_askamount)*(custentity_probability) under default value in validation & defaulting.
However, I get this in the projected amount field: ERROR: Invalid Expression.
Does anyone know how to help make this happen? Or is there something else I should be using to calculate probability?