Error with AND Statement

[Anonymous]

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

[v-lid-msft]

Hi @Anonymous ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft]

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,

[VasTg]

@Anonymous 

Looks like the Sprintdata table is not related(no relationship defined) to the table where you are trying to create the new column. 

I would also recommend you to use variables to get the RELATED values and use them in the IF statement.

[amitchandak]

What are you trying to achieve?  Please provide more details