No open parentheses error on formula

Question

Hi 
 If anyone could help it would be greatly appreciated. 
 I need to add an element to my working formula below (by working formula i mean it is already in place and working as i would like but have a new requirement that i need to add in) 
 What the formula currently does: If 'total paid' is greater than 0, put this field as 0. If not, if the net value is greater than &pound;50,000 then this field should be &pound;6,000, if not this field should be 10% of gross value 
 
 Working formula: 
 ifElse( greaterThan( $pr_total_paid_c, 0 ), "0", ifElse( greaterThan( number( $pr_net_value_c ), 50000 ), add( 5000, multiply( 5000, divide( $pr_payment_rate_c, 100 ) ) ), multiply( $pr_payment_gross_value_c, .1 ) ) ) 
 
 What i need to add: If Project type is equal to "Supply and Fit" or "Supply and Fit 2023" and net value is greater than &pound;50k ... 
 New formula (i have added this below in yellow but am getting 'no open parentheses' error) 
 ifElse( 
 greaterThan( 
 $pr_total_paid_c, 
 0 
 ), 
 "0", 
 ifElse( 
 (equal($pr_project_type_c,"Supply and Fit"),equal($pr_project_type_c,"Supply and Fit 2023") 
 and( 
 greaterThan( 
 number( 
 $pr_net_value_c 
 ), 
 50000 
 ), 
 add( 
 5000, 
 multiply( 
 5000, 
 divide( 
 $pr_payment_rate_c, 
 100 
 ) 
 ) 
 ) 
 ) 
 ), 
 multiply( 
 $pr_payment_gross_value_c, 
 .1 
 ) 
 ) 
 ) 
 
 if anyone has any suggestions of what i may have missed or what i can do to fix this, please let me know! 
 Thanking you in advance

Penny Whitlock · Accepted Answer

Hi Penny Whitlock , If I understood your requirement, you are looking something like this. ifElse(
 greaterThan(
 $pr_total_paid_c,
 0
 ),
 "0",
 ifElse(
 and(
 or(
 equal($pr_project_type_c, "Supply and Fit"),
 equal($pr_project_type_c, "Supply and Fit 2023")
 ),
 greaterThan(
 number($pr_net_value_c),
 50000
 )
 ),
 add(
 5000,
 multiply(
 5000,
 divide(
 $pr_payment_rate_c,
 100
 )
 )
 ),
 multiply(
 $pr_payment_gross_value_c,
 0.1
 )
 )
)
 PS: Its recommend to use Insert menu to use code feature for better code transfer. Let me know if this works. Tevfik T&uuml;mer Sr. Developer Support Engineer

Penny Whitlock · Answer

Hi Penny, 
 If I understand your desired changes, the formula should look like this: 
 ifElse(
 greaterThan(
 $pr_total_paid_c,
 0
 ),
 "0",
 ifElse(
 and(
 or(
 equal(
 $pr_project_type_c,
 "Supply and Fit"
 ),
 equal(
 $pr_project_type_c,
 "Supply and Fit 2023"
 )
 ),
 greaterThan(
 number(
 $pr_net_value_c
 ),
 50000
 )
 ),
 add(
 5000,
 multiply(
 5000,
 divide(
 $pr_payment_rate_c,
 100
 )
 )
 ),
 multiply(
 $pr_payment_gross_value_c,
 .1
 )
 )
) 
 Chris

Penny Whitlock · Answer

Hi Penny Whitlock 
 
 Perhaps this update will fix the issue: 
 ifElse( greaterThan($pr_total_paid_c, 0), 0, ifElse( greaterThan(number($pr_net_value_c), 50000), add( 5000, multiply( 5000, divide($pr_payment_rate_c, 100) ) ), multiply($pr_payment_gross_value_c, 0.1) ) )