Forum Discussion

prakritnepal-cn's avatar
prakritnepal-cn
Frequent Visitor
5 years ago
Solved

cannot convert value text to type true/false

Hi, 

 

I am trying to use sumx to calculate a total column. I get following error of cannot convert value type: 

 

My formula used is (on the screenshot as well) : sumx( filter (table1, related (table2'[column with one to many join with table1)]) && bunch of criteria),Table1[balance]) 

 

table relationship screenshot: 

 

 

How can I modify the formula to go around this error?

 

Thank you for your help

 

 

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    prakritnepal-cn - I have to believe that the error is coming from your RELATED function. I would try removing that to see if it is in fact the issue.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    prakritnepal-cn - I have to believe that the error is coming from your RELATED function. I would try removing that to see if it is in fact the issue.

  • Chilarejo5's avatar
    Chilarejo5
    New Member
    5 years ago

    Hi everyone,

     

    I am trying to define define an "Implemented state" in a column; where I have to identified if it is "Imported into Production" or "Completed" this must be identified as Implemented:

     

    If(OR(modified[Status] = "Imported into Production" , "Completed"),"Implemented","No Implemented")
     
    Warning message is showing: Cannot convert value 'Completed' of type text to Type True/False
     
    What can I do for fix it?
     
    Thanks!