I am trying to populate a table with ONLY items where certain values do not match one another.
For example, in the calculation condition of my table box I currently have written:
ALLOCATION_CODE1 <> HOME_CODE1 or ALLOCATION_CODE2 <>HOME_CODE2 or ALLOCATION_CODE3 <> HOME_CODE3
So in theory, I am only trying to display items where the allocation code 1, 2 or 3 does NOT match the home code 1, 2 or 3. The syntax above is not working and I am still getting items where the codes match.
Calculation condition of your table box object is not the best place to do it. The reason is because the calculation condition will either be true or false for the whole table. If its true, it will display everything, if false will not display anything. You might have to switch to a straight table for this and may be use a expression for your condition.
Still struggling with this. I have decided to try and do the match comparison in the data model script instead of in the application but I am still coming up short
Basically, I have the following table structure:
Table 1
Key
Employee
Report
Field 1
Field 2
Field 3
HOMECODE1
HOMECODE2
HOMECODE3
HOMECODE4
Table 2
Key
ALLOCATIONCODE1
ALLOCATIONCODE2
ALLOCATIONCODE3
ALLOCATIONCODE4
Are there any recommendations of how I can either combine these tables to easily do the comparison? Again, I am trying to figure out a way to display ONLY fields where the HOMECODEs DO NOT match ALLOCATIONCODEs
