English Boards > Support

Trying to print positive instead of neg on Ticket Account Bal val.

(1/1)

pecanhouse:
I use the system for gift cards I apply a negative balance to account bal but is there a way just to alter print job have this so far:

<F>=
<EB>
<J10>{IF DISCOUNT}
<J10>[Total Gift:|{GIFT TOTAL}]
<J10>Sales Tax:|{TAX TOTAL}
<J10>Total:|{TICKET TOTAL}{IF PAID}
<J10>
<J10>Tip:|__________________
<J10>Total:|__________________
<J10>
<J10>Signature:
<F>_
<F>-
<J10>[Account Balance:|{ACC BALANCE}]
<J00>Remaining Balance before tip:|[= Format (ToNumber ('{ACC BALANCE}') + (ToNumber ('{TICKET TOTAL}')))]
<DB>
<F>=
<C10>T H A N K    Y O U

if its possible to Multiply the acc bal by -1 should work ?

Tried
[= Multiply by -1 Format (ToNumber ('{ACC BALANCE}') + (ToNumber ('{TICKET TOTAL}')))]


Thanks for any sujestions

emre:
Can you try?

[=Format(Abs(ToNumber('{ACC BALANCE}')+ToNumber ('{TICKET TOTAL}')))]

pecanhouse:
Thanks the only prob with this is that if some one goes over the account bal it still shows positive. Thank you though I'm am not familiar on how to group formulas  together but i added another ToNumber to the mix thanks thanks for the help!

<F>=
<EB>
<J10>{IF DISCOUNT}
<J10>[Total Gift:|{GIFT TOTAL}]
<J10>Sales Tax:|{TAX TOTAL}
<J10>Total:|{TICKET TOTAL}{IF PAID}
<J10>
<J10>Tip:|__________________
<J10>Total:|__________________
<J10>
<J10>Signature:
<F>_
<F>-
<J10>Account Balance:|[= Format (ToNumber ('{ACC BALANCE}')*-1)]
<J00>Remaining Balance before tip:|[= Format (ToNumber (ToNumber ('{ACC BALANCE}') + (ToNumber ('{TICKET TOTAL}')))*-1)]
<DB>
<F>=
<C10>T H A N K    Y O U

Navigation

[0] Message Index