L1 Act 5 Error: Data type mismatch: format other than LIST or DATE being referenced as a relation

denzalvin
denzalvin
in Modeling

Update: Thanks to the community. I have completed and passed the Level 1 test.

 

I think I entered the correct formula for editing the formula, but I am getting the error above. I think I get it that there is a mismatch in the format, but I am not sure where to look for it I also think that each data type I checked are all the same. I am missing something, any guidance will be helpful. Thank you. Could it be to the Format of the Role item added from prior questions? When I edit that into a list, set to Role, I am getting an error

 

Tagged:

Answers

  • anand.shekhawat
    anand.shekhawat

    @denzalvin 

    This error message means that the format of your line item does not match the result of your formula or you might be trying to Sum/Lookup a value that doesn't match your line item format. Here when you are trying to change the format, possibly the already written formula does not satisfy the format criteria of that line item. 

     

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

  • denzalvin
    denzalvin
    Thanks for the response, Anand.

Categories