How to format a field depending on the value of another field?
I have a problem, I want to format one field depending on the value of another field and I can't find any way to do it. I though I can use a custom function or an custom advanced function, but then I would have to return Strings, which probably won't play nice with aggregations on the report. I also can't use a custom formatter, because according to the documentatione it does not allow me to access the values of a different field.
In the current use case I have a column with a value and a second column that tells me what kind of value it is. e.g. a € amount or a % amount. Depending on the type I would liket to format to <value> % or <value> €. I might even have to change the percision.
But I need to be able to aggregate the values of the same type when I add another dimension onto the report.
Any ideas on how to achieve this? Am I missing something?