How Can I Calculate Percentage?

  • Resolved wcs2

    (@wcs2)


    4 years, 8 months ago

    Hi,
    I’d like to calculate a percentage using two sets of fields – one set divided by the other, represented as a percentage.
    For example: (x/y)*100
    How can I do this?

    I have tried the following in a Total field and can only get it to appear as a dollar amount:
    ( ( (( quantity_field_id_0 * quantity_field_id_1 ) * ( range_field_id_9 * .01 )) – ( quantity_field_id_0 * .002 ) ) / ( quantity_field_id_0 * .002) ) * 100

    • This topic was modified 4 years, 8 months ago by wcs2.

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Axel StylemixThemes

    (@axelstm)

    Hi @wcs2

    You need to use the decimals with integers. The Total doesn’t accept numbers in this format – .01 and.002.

    regards

    Thread Starter wcs2

    (@wcs2)

    The math works, but instead of showing as %, it shows $. I know I can change the symbol for the Total fields, but that means it changes every Total field. Basically, what I want to do is say something like this:
    You saved
    $30
    that’s a savings of
    24%

    So, 2 different Total fields with 2 different symbols.
    Is this possible?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How Can I Calculate Percentage?’ is closed to new replies.