Calculation

[ShelleyK]

THIS HAS BEEN RESOLVED

 

 

I have a calculation that returns point totals in a table. See below. I need this to look for the Yes flag from another table and only count those points. So I need to add from the Events2016 table only count if the flag for ResultsApproved = Yes

Can someone assist in completing this script?

 

 

select

case

when sum(b.CCO_Place_Points) > [@field:State_Points_Required_Required_Points] then 'Yes'

else 'No'

end

from ResultsChili2016 a

join Lookup_Places b on b.CCO_Place_ID = a.PlaceID

where a.MemberID = [@field:Member2015_MemberNo]