Trouble with final total.

  • Profile Image
    triciadunham
    Asked on April 23, 2015 at 12:25 PM

    Hi there, I got my form all set up, thanks to your great help! 

    Now I have the order total coming out right, then we have a $30 credit being applied to that amount, and it comes out correct into the Final Pricing box.  The problem is in the Paypal amount or My Products box, if there is a negative amount we need it to zero out. As it is, if a negative amount gets totaled into the final pricing box, that negative gets changed to a positive amount in the my products box.

    Is there any way to fix that? I have played around in there, but haven't came up with a solution.

    If that could get zeroed out when there is a negative balance due, that would be great. If not, is there some way to go around that somehow? We only want to proceed to charge them if there is an overage above the $30 credit.

    I hope all of that made sense. :)

    Thank you,

    Tricia

  • Profile Image
    KadeJM
    Answered on April 23, 2015 at 01:12 PM

    Thank you for the explanation about this Tricia. To my understanding you mainly want to have any negative balances negated unless it is an overage that ends up being a positive amount above the existing $30 credit which you are giving your clients.

    Our form calculations do allow for much more complex calculations to occur so there is a good chance that something to that effect might be a possibility and we are certainly more than willing to try to help find a solution to resolve this issue of yours.

    I will need some time to look into this more to see if I can figure something out for this and get back to you about it as soon as possible.

    In the meantime you may want to take a look at http://www.jotform.com/help/267-Form-Calculation-Math-Function-Reference to get a better understanding of using more complex calculations which you might find helpful.

  • Profile Image
    triciadunham
    Answered on April 23, 2015 at 06:09 PM

    I got it, the link answered my question. I ended up putting a couple of subtotal boxes to pull from and used the link to http://www.jotform.com/answers/368029 to answer my question. Thanks so much. Your customer service is awesome.  :)