I have a table and 2 columns are calculated columns I want to take the difference between the 2 columns and show an indicator based on that
here is the formula
But it says I can't use an aggregate
I have another column that uses this expression but if I try to use it for the indicator I get the same error about aggregates.
Does anyone have any suggestions on how to do this? The one field is coming from another data set