Formula help

Hi Penny Whitlock ,

If I'm understanding your requirements correctly, then the formula should be:

ifElse(
    greaterThan(
        $pr_net_value_c,
        50000
    ),
    add(
        5000,
        multiply(
            $pr_net_value_c,
            divide(
                $pr_payment_rate_c,
                100
            )
        )
    ),
    multiply(
        $pr_payment_gross_value_c,
        .1
    )
)

Your requirements state that if the value is under 50,000 pounds, then the field should have 10% of the gross value. I'm not clear why your original formula is attempting to subtract pr_total_paid_c from 10% of the pr_payment_gross_value_c field. I am assuming pr_payment_gross_value_c is the gross value, so I removed the subtraction element to only provide the 10% value of that field to match your stated requirement.

Also, your original formula had two extra opening parentheses and not enough closing parentheses. I find it easiest to write out formulas with tab indents like above to easily track when parentheses are needed.

Chris

Hi Chris

thanks for your help - i am getting this error

greaterThan: The parameter at index 1 must be of type number

Hi Chris

thanks for your help - i am getting this error

greaterThan: The parameter at index 1 must be of type number