Gift certificates reports multiply by -1

V5 Question
8

Only because “I can’t help myself!”

>Balances no zeros
[List:1,1]
{REPORT ENTITY DETAILS:
	E.Name,
	E.Balance.Sum;P0.00;N0.00;Z0.00:
	(ET=Customers) && E.AccountID>0:
	{0} | ${1}::$2!=0:}

I have no idea why but this also works:
[EDIT] This is wrong as the formats are not obeyed i.e. “$” in “$23.69”.

>Balances no zeros
[List:1,1]
{REPORT ENTITY DETAILS:
E.Name,
E.Balance.Sum;P0.00;N0.00;Z0.00:
(ET=Customers) && E.AccountID>0:::$2!=0:
{0} | ${1}}

Guys were working on some good documentation here:

Notes:

  1. You need to include “.sum” as it must convert E.Balance to Numeric of something internally
  2. The $2!=0 means 2nd Column Field not equal to 0.

Still don’t understand the 3 colons ":::" requirement and why when they are placed bottom or 2nd bottom line it works?

1 Like