I have a chart with the following data (see below chart 1). I'm trying to add a column, "Threshold Achieved" and I need to display 'Yes' in the "Threshold Achieved" column when all Primarys have exceeded the Threshold Points Earned. So I really need to loop through the rows for all primarys to evaluate if a Yes/No should go into the column. Is this possible? I started out trying to use the following expression, but it is generating null records in the chart (see below chart 2). Thanks
If (SalesLevel = 'Primary',
If ([Target Points Earned] < [Threshold Points], 'No',
If ([Target Volume] = 0, 'N/A',
If ([Target Points Earned] >= [Threshold Points], 'Yes',
If (below([Target Points Earned] < [Threshold Points]), 'No')))))
for me it looks like your expression isn't valid (or has a null as result) always when [Threshold Points] isn't valid (or null). You can see it starting with line three. So try to find out how to "repair" this field.
In the last line you got a valid expression although [Target Points Earned] isn't valid. This is luck, better to say because of the above() function.