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.
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.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.