RE: Saved Search Formulas

I am new to NetSuite formula expressions used in saved searches- I am trying to divide two expressions that is working, but every time that I try to divide them I get a “ERROR”, Please Help

Expression 1- Formula (Numeric) Sum Round to Hundredths sum({custrecord_iqity_prod_sum_clock_hrs}) / 60

Expression 2- Formula (Numeric) Minimum Round TO_CHAR({custrecord_iqity_prod_sum_date}, ‘d’)*{custrecord_iqity_prod_sum_workcenter.custrecord_iqfwchoursperdaylab}

Divide Expression 1 / Expression 2

My formula that is not working (and I don’t know where it is wrong ) Formula (Numeric) Sum ((SUM({custrecord_iqity_prod_sum_clock_hrs}) / 60) / (SUM(NULLIF({custrecord_iqity_prod_sum_date}, ‘d’)*({custrecord_iqity_prod_sum_workcenter.custrecord_iqfwchoursperdaylab}),0)))

rddasilva Rookie Asked on March 5, 2021 in Saved Searches.
Add Comment
1 Answers

Probably need to copy and paste your formula better. The denominator is not equal to expression 2 in your combined formula.

If its not the copy and paste problem, you will need to be share more about the field types of the custom fields.

Intermediate Answered on March 5, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.