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!
Referencing 2 formula columns
Hello
I am trying to create a formula that provides a value based on the calculation of two other fields. I am using the sales order record as the base for my Saved Search.
Row 1:Internal ID Count
Row 2: Formula (Numeric) Sum
CASE WHEN {item.internalid}=6 THEN 1 END
Row 3: Formula (Numeric) Maximum
count({internalid})*SUM (CASE WHEN {item.internalid}=6 THEN 1 END)
Row 1: has a calculated value of 4 which is correct
Row 2: has a calculated value of 6 which is correct
Row 2: has a calculated value of 36 which is not correct
what I would like is for row 3 to have is a calculated value of 24 (4*6).