Crystal Reports: Formula to pull data point where other specific criteria are met -
i'm positive pretty easy formula i'm quite new cr , having difficult time this...searched answer couldn't find it, please forgive me if has been asked ad nauseam. i have list of patients , each year patient assigned risk score, each patient has multiple scores. data looks this: patient_id score_year risk_score 11111 2013 1.05 11111 2014 0.00 22222 2013 0.07 22222 2014 0.11 33333 2013 1.19 33333 2014 0.00 44444 2013 2.13 44444 2014 0.00 55555 2013 0.30 55555 2014 0.54 66666 2013 1.67 66666 2014 2.31 i want create field assigns single risk score each patient can see data, patients have '0.00' 2014, don't want include. my thought create formula states if [score_year] = 2014 , [risk_score] <> 0 ([risk_score] [score_year] = 2014) else ([risk_score] [score_year] = 2013) hitting brick wall. in nutshell, need formula pu...