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

4 Replies

  • VasTg's avatar
    VasTg
    Memorable Member
    6 years ago

    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.

     

     

  • 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,

     

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    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,