I had this:
[<J00>Your New ShakesCard Balance:| £[=F(TN('{ENTITY BALANCE:ShakesCard}'))]]
which shows negative
I tried this:
[<J00>Your New ShakesCard Balance:| £[=F(TN('{ENTITY BALANCE:ShakesCard}','#,#0.00;#,#0.00'))]]
Which shows nothing… (based upon what I read on the forum)
Where have I gone wrong?
Matt
JTRTech
2
What you trying to do? Inverse the credit/debit number?
Try something like
0-({ENTITY BALANCE:ShakesCard})
10 (debt) = 0 - 10 = -10 (negative)
0 = 0
-10 (credit) = 0 - (-10) = 10 (positive)
1 Like
Had to play about with it a little,. but ended up with the desired result.
who woulda thought just 0- would do so much lol
Matt