In my bar chart I would like to show the max and min Amound in different colours, somehow this works in year 2012 YTD only but not in the other 2 years. Can anyone tell me what is wrong with my formula? Would be great if anyone could help.
if I understand your request correctly, I think one issue is that you need to aggregate the kurzfr. Überschusshöhe prior to finding the min/max. You can do this using advanced aggregation, maybe along these lines
I needed to add small numbers (could be even much smaller, like the smallest amount that could be represented), since QV seemed to have problems with comparing the floating point values on at least one minimum value (Comparing floating point values is always an issue, I assumed it should work here since the calculations are essentially identical, but I was wrong).
if I understand your request correctly, I think one issue is that you need to aggregate the kurzfr. Überschusshöhe prior to finding the min/max. You can do this using advanced aggregation, maybe along these lines
I needed to add small numbers (could be even much smaller, like the smallest amount that could be represented), since QV seemed to have problems with comparing the floating point values on at least one minimum value (Comparing floating point values is always an issue, I assumed it should work here since the calculations are essentially identical, but I was wrong).
