I am looking to sum the total number of "Std Cav" when pdadyprod_id = pdayprod_id. I've tried many things, nun which has worked, my latest attempt leaves me with an error "From keyword not found where expected". Please advise.
Whenever pdayprod_id equals itself, add the number of std cav to get a "Part Count"
