Details about this thread
  • State Not Answered
  • Replies 1 reply
  • Subscribers 323 subscribers
  • Views 723 views
  • Users 0 members are here

Calculation formula help!

Penny Whitlock

I need a formula to say: 

calculate 5% of the gross value and display which ever figure is lower between 5% of 'gross value' and 'Total Outstanding' 

any help is much appreciated!

  • 0

    Hi ,

    The formula you would need to use would be something along the lines of:

    Fullscreen
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    ifElse(
    greaterThan(
    $total_outstanding,
    multiply(
    .05,
    $gross_value
    )
    ),
    multiply(
    .05,
    $gross_value
    ),
    $total_outstanding
    )
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

    Using the greaterThan function allows you to compare the two fields and ultimately decide which field value is displayed through the ifElse function.

    Chris

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