So, your initial post has a bunch of IF statements that are attempting to test several parameters (i.e., reportdate_int, inspection_date_int, mxwostatus, and issuegroup). But, in your S123 layer above, it appears that your "Pavement Areas" group has already determined if the area is either "unsatisfactory" or "satisfactory". If this determination has already been made in the S123 app, what is the point of the IF statements in the Feature Report? You could just reference "Pavement Areas" alone.
------------------------
"Maybe it would be better to use the count_pvmnt from the layer BWI Part 139 Inspection but then how would I have it display satisfactory or unsatisfactory because that's what I would like it to show for this statement."
"...where the first one would try to determine if there is a greater than zero count of “pending” issues for that issue group. If there is a greater than zero amount, it should display Unsatisfactory."
${if BWI_Part_139.count_pvmnt>0}Unsatisfactory.${/}
"The second ... is supposed to do the exact opposite and is looking for the count of pending issues in the issue group to equal zero, in which case it would display satisfactory."
${if BWI_Part_139.count_pvmnt==0}Satisfactory.${/}
Then together:
${if BWI_Part_139.count_pvmnt>0}Unsatisfactory.${/}${if BWI_Part_139.count_pvmnt==0}Satisfactory.${/}
------------------------
"I want this to specify based on the date I am giving it which is "inspection_date_int" tell me if it is Unsatisfactory or Satisfactory for specifically "issuegroup" Pavement Areas between the "mxwostatus", 'COMP' and 'CLOSE'. (we just changed these values)"
Can you please provide the field names, types, and what the interaction looks like?
E.g., Only where issuegroup equals "Pavement Areas", reportdate_int is less than to equal to inspection_date_int, and mxwostatus is not equal to "Complete" or "Closed".
Here is a (maybe) fixed version for your initial IF statement. May help.
${if reportdate_int<=BWI_Part_139_Inspection.inspection_date_int && mxwostatus!="Complete" && mxwostatus!="Closed" && issuegroup=="Pavement Areas"}Unsatisfactory.${/}