Forum Discussion

cheezy's avatar
cheezy
Icon for Helper I rankHelper I
6 years ago

Calculated Field formula doesn't work as intended

eGFR Months = DATEDIFF(app_appointments[eGFR_test_date],TODAY(),MONTH) Age = FLOOR(IF([dob]< TODAY(), DATEDIFF([dob], TODAY(), DAY) / 365.25, 0), 1)   i have two calculated fields in different t...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

cheezy , you need row value then it should be the max not selected value.

Please find one formula changed

 

Blood Test =
IF( (max(app_patient_details[Age]) >69 && max(app_appointments[eGFR months]) > 0), "Blood Test","Not Working")

cheezy's avatar
cheezy
Icon for Helper I rankHelper I
6 years ago

This didn't work unfortunately- all rows return blood test now irrespective of age or egfr