I'm having a problem with the filter including all of the values. I'm using the following from a secondary data source:
not(. = ../preceding::dfs:_18-740-886-402_pg14/@kV)
I also have an additional condition specified that the name from the Main data source match the name from the secondary (sharepoint list) (i.e. BreakerSelection is equal to Type1). This is in order to determine which kV data to return to the list
The data I am testing for this filter is 4.76, 8.25, 8.25, 8.25, 15, 15, 15, 15, 15, 15, 15
The filter only returns 8.25 and 15 for the dropdown, why is it not including 4.76 since it is itself a unique value?
One would assume that 4.76 does not meet the two criteria you have set with the "not" statement and the value matching statement. Have you removed one or both criteria to see if 4.76 shows up in either or both cases?