No open parentheses error on formula

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 £50,000 then this field should be £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 £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

Parents Reply Children