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...
FarhanAhmed's avatar
FarhanAhmed
Icon for Community Champion rankCommunity Champion
6 years ago

Hi cheezy 

SelectedValue works when you have column returns 1 value from column. If your column is aggregating , lets say 71 is for multiple people on given selection it will return NULL value and hence your if statement will never get true and returns "Not Working"

 

See screenshot for the reference.

 

You might need to use other aggregate function or include further granuality on your table selection to have desired results.

 

Regards