Details about this thread
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 314 subscribers
  • Views 633 views
  • Users 0 members are here

Parenthesis Issue on Formula

Penny Whitlock

Fullscreen
1
2
3
4
5
6
7
8
ifElse(
greaterThan($pr_total_paid_c, multiply($pr_payment_gross_value_c,.45)
,"0",
)
ifElse(
subtract(multiply($pr_payment_gross_value_c,.45)),
$pr_10_percentage_suggested_c,
$pr_total_paid_c)
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Please tell me where i have gone wrong with this formula - Im not sure why it is not working, i think i just have my brackets misplaced!

I am trying to do 

If Total Paid is more than 45% Gross Value put "0" 

otherwise, workout 45% gross value minus 10% suggested field value minus total paid

Any help is greatly appreciated! 

  • +1

    Hi  ,

    Based on your requirements, I believe this is how you want the formula to be structured:

    Fullscreen
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    ifElse(
    greaterThan(
    $pr_total_paid_c,
    multiply(
    $pr_payment_gross_value_c,
    .45
    )
    ),
    "0",
    subtract(
    multiply(
    $pr_payment_gross_value_c,
    .45
    ),
    $pr_10_percentage_suggested_c,
    $pr_total_paid_c
    )
    )
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

    Let me know if that works!

    Chris

    Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year

  • 0 in reply to Chris Raffle

    Ahhh that makes so much sense now! Thanks Chris, I am slowly starting to get a hang of this now Slight smile

    thanks so much for all your help!