I am trying to create a formula for a report that will essentially go to a child table, look for a certain screening, and if it is required, return the Expiration Date of the screening. If the screening is not required, I would like it to just return N/A. I figured the formula would be something along the lines of...
<<IF(
SELECT(Screenings[Screenings ID], AND([Screenings ID]=[_THISROW].[Screenings ID],[Screening]=“OIG Exclusion”, [REQUIRED]=”TRUE”)),
(Screenings.[Expiration Date]),
“N/A”)>>
but I am getting the error "is invalid due to: IF function is used incorrectly: the first input should be a condition that returns true or false." Any thoughts on what I am missing?
IF(
SELECT(Screenings[Screenings ID],
AND(
[Screenings ID]=[_THISROW].[Screenings ID],
[Screening]=“OIG Exclusion”,
[REQUIRED]=TRUE
)
) = ?...required for condition of true...? ,
[Screenings].[Expiration Date],
“N/A”
)
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |