PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Total Value devided by 12

  1. roey.saban
    Member

    Hi guys

    Please see this page: http://www.myistoreb2b.co.za/contractdeal/

    How do I get the "total" field in this form at the bottom, to calculate the total number BUT devide it by 12?

    The iPad values should be added to the grand total, but should devide it by 12 as customer will be paying over 12 months - how do I do this?

    Posted 11 years ago on Thursday May 23, 2013 | Permalink
  2. David Peralty

    You would add in a Product with a Calculation type and then take all of your merge tags for your products and add them together (like making your own total field) and then divide it by twelve, multiply by 11 and make it a negative number. Then your total will reflect a single month's payment amount. I'm sure there is faster math to do this, but my brain is a bit slow this afternoon.

    Posted 11 years ago on Thursday May 23, 2013 | Permalink
  3. roey.saban
    Member

    What I have done, is said product 1 PRICE x product 1 QUANTITY + product 2 PRICE x product 2 QUANTITY / 12

    Then the calculation is wrong....can I only use quantity or price?

    Posted 11 years ago on Friday May 24, 2013 | Permalink
  4. Maybe this tutorial could be of some value: http://gravitywiz.com/subtotal-merge-tag-for-calculations/

    Posted 11 years ago on Friday May 24, 2013 | Permalink
  5. roey.saban
    Member

    Hey

    Added the snippet to my functions.php file and whole site gone blank

    Something else I can try?

    Posted 11 years ago on Friday May 24, 2013 | Permalink