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!
Looking for the statement that will evaluate the difference between two fields and if negative, retu
I created a calculated customrecord Integer Number field and am using it to calculate the difference between an 2 other fields (actual count and the # included) but if the result is negative, I'd like the value returned to be 0 (zero)
My current formula is: {custrecord_cd_usage_actual}-{custrecord_cd_usage_included} but often actual usage is less than included usage so a negative value is returned.
I am looking for the statement that will evaluate the result and if negative, return 0 (zero).
Can anyone help? Thanks