Forum Discussion

22LACMT's avatar
22LACMT
Helper III
3 years ago
Solved

Switch functions error

Does anyone know why I am getting this error? and how to fix it?    OverallstarRatingNR = SWITCH( ProviderInfo[Overall Rating] = "0", "Not Rated", ProviderInfo[Overall Rating] = "1", "1",ProviderI...
Need Help
  • SamInogic's avatar
    SamInogic
    3 years ago

    Hi 22LACMT ,

    You are actually adding ProviderInfo[Overall Rating] ="0" in your formula as mentioned above. It should be as below,

    SWITCH(ProviderInfo[Overall Rating],"0", "Not Rated","1","1","2","2","3","3","4","4","5","5")

    Let me know if you still faces the issue.

    Thanks!

     

    Inogic Professional Services Division

    Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

    Drop an email at [email protected]

    Services:  http://www.inogic.com/services/

    Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

22LACMT's avatar
22LACMT
Helper III
3 years ago

Hi, I feel like there is something (maybe on a formatting level) missing.  

 

OverallstarRatingNR = SWITCH( ProviderInfo[Overall Rating] ="0","Not Rated","1","1","2","2","3","3","4","4","5","5")
 
I'm still experiancing the Switch fuction error : "Function switch does not support comparing values of type true/false with values of type text. consider using the Value or FORMAT function to convert on of the values. 
SamInogic's avatar
SamInogic
Super User
3 years ago

Hi 22LACMT ,

You are actually adding ProviderInfo[Overall Rating] ="0" in your formula as mentioned above. It should be as below,

SWITCH(ProviderInfo[Overall Rating],"0", "Not Rated","1","1","2","2","3","3","4","4","5","5")

Let me know if you still faces the issue.

Thanks!

 

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at [email protected]

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/