We would like to sum a quantity field per group in Report Designer. Is this somehow possible?
To be more precise; we want to sum the quantity per Custom Stat no in the Delivery Note for Shipment.
Best answer by MiLeNL
View original
HELLO JUR!
Hope you are doing well ;-).
Somehow it is possible, but i can't think of a very nice solution. If you only have a few Custom Stat No, you can put in a condition in the report for each stat group. Like below example.
Then it is possible to sum;
However, it will cause a lot of work if the custom stat groups change. Perhaps it's possible to fetch the custom stat no as a list and filter it dynamically with the StrCase function. But that will be a lot of trial and error.
Hi stranger! I’m doing fine. 😀
You triggered me with the StrCase but I couldn’t get that to work. However, I’ve got it working up untill a point I think is acceptable. I put everything in a single custom field with a listagg, and used the replace function to replace the seperater with a ‘$new_line’. That worked so far!
Always need to be a bit creative 😀
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.