Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Error with AND Statement

Hi All,   I have this Calculated Column:   But I got this error message:   The thing is that those two tables have relationship between.   Any suggestions? Thanks
Need Help
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

Could you please share the relationship between the three tables if it does not contain any confidential information? If the 'BurnUpPointsData' Table have a "one to Many" relationship with other table, we cannot use Related to get the value, because related can only get one value but there maybe many possible value in "one to Many" relationship , we need to chang the formula using other function based on particular condition.

 


Best regards,