If I add a listbox with only the customer field I have the following situation:
Customer
PLUTO
PIPPO
Now the question is: How can I have in the list box only the presence of the PLUTO customer, I don't want the customers where the difference between credit and debit is zero.
You need to solve this piece in the script instead of UI. I'm sharing part of the script and you can use the below script to integrate in your application.
//This code is incremental reload where we are filtering Customers where DR & CR amount are not equal
NoConcatenate
LOAD
Customer ,
New_Customer
where CR_Amount <> DR_Amount;
//This code is resident load where we are grouping DR & CR amount
Final:
LOAD Customer , Customer as New_Customer, Sum(Credit) AS CR_Amount, Sum(Debit) AS DR_Amount
Resident Test
Group by Customer;
If this is not clear... please share full script or sample application.
