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, rel...
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.

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!