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!
Can a Saved Search Formula Reference Another Column?
Is there a way to reference another formula column in the same Saved Search? For example, I have a formula column (simplified for discussion) called 'Qty to Order' that is defined as NVL({preferredstocklevel},0)-NVL({quantityavailable},0). Is there any way in the same Saved Search to have another formula column that references the previous column? Again, keeping it simple for discussion, suppose the in the second column I wanted to multiply the first column by 5. Is there a way to make the formula 'Qty to Order' * 5 rather than duplicating the original formula as )NVL({preferredstocklevel},0)-NVL({quantityavailable},0))*5? I