Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Problems using {actualtime} in formulas
I'm currently trying to create a custom entity field that uses {actualtime} in a VERY simple expression.
I have one custom entity field that is a decimal showing the total number of hours a customer has purchased. I need to be able to subtract the {actualtime} from this value to populate a separate custom entity field, i.e.
Hours Purchased = 80
Actual Work = 8:00
Remaining Hours = 72
I've tried creating a Remaining Hours field (type: Decimal Number) that has a Default Value formula of {customHoursPurchased}-{actualtime}, yet I am getting "ERROR: Invalid Expression"
Is there ANY way to easily convert the {actualtime}, {estimatedtimeoverride}, etc numbers so that they're actually usable in formulas?