I am having some trouble including a condition in my set analysis.
Goal: count the products id from my max month year ( it works), for a certain level type (also works), and for when the field value is greater than the 3% of the total value sum (with the same filters). This is where I am having trouble. The field value can be positive and negative, but I need to ignore it and just use absolutes, the fabs.
If I use the following set analysis, it will only give back the values ( not absolute values) that are grreater than the 3% of total value (colored in orange in the image), which is almost what i want, i just need to include the absolute values somewhere. It is counting 2 ids instead of 7 (see image):