No open parentheses error on formula

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)
)
)

Hi Andre, isnt that just reverting the code back to what i already have? I need to add the new term into it "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 ..." as explained above 

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
    )
  )
)

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

Thank you so much! This has worked 
How do I use Insert menu to use code feature sorry?

Fab thank you so much!

I'm glad it worked. :) 

When you are typing your messages in this editor there is a menu (Edit | Insert | Format | ...) 
Using Insert > Code you can paste your code. Then it would look like the code in my answer. 

Hope it helps for your further questions. 

Tevfik Tümer
Sr. Developer Support Engineer