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!
Formula too long
I am trying to write a formula whereby there are multiple conditions that are too long in total for the formula field in a custom field:
[CODE]
CASE
WHEN {customrecord.internalid} = '1759' and {customstartdate} BETWEEN '07/01/2012' and '08/01/2012' THEN 1
WHEN {customrecord.internalid} = '1759' and {customstartdate} BETWEEN '08/01/2012' and '09/01/2012' THEN 2
WHEN {customrecord.internalid} = '1759' and {customstartdate} BETWEEN '09/01/2012' and '10/01/2012' THEN 3
WHEN {customrecord.internalid} = '1759' and {customstartdate} BETWEEN '10/01/2012' and '11/01/2012' THEN 4
WHEN {customrecord.internalid} = '1759' and {customstartdate} BETWEEN '11/01/2012' and '12/01/2012' THEN 5
...
END
[CODE]