Trying to add this simple calculation

  • Resolved andrewgoode1900

    (@andrewgoode1900)


    6 years, 2 months ago

    We are looking to create the following formyula / calculation whereby the person can add in gross profit margin % , add in the price increase % and then the calculation shows the amount sales can fall

    In excel sheet the formula =ABS(B3/(B3+B5)-1) provides the answer ( would be a negative so Absolute value used)

    How do I achieve this in Calculated fields form

    KR Andrew

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    6 years, 2 months ago

    Hello @andrewgoode1900

    Assuming B3 is the fieldname1 field, and B5 the fieldname2, the equation would be:

    
ABS(fieldname1/(fieldname1+fieldname2)-1)*100

    If you want the result with only one decimal place:

    
PREC(ABS(fieldname1/(fieldname1+fieldname2)-1)*100, 1)

    Best regards.

Viewing 1 replies (of 1 total)

The topic ‘Trying to add this simple calculation’ is closed to new replies.