Sum per group in Report Designer

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!