Forum Discussion

Lancelot's avatar
Lancelot
Frequent Visitor
3 years ago

Cannot convert value of type text to type integer

Hi All

 

I have a measure that works perfectly fine on one of the pages but not on ther orther.

 

Margin = [Revenue] - [Total COS]

 

The results on the one page is correct. However, when I try to call the the same measure on a different page, I get the error above. Please assist. 

 

Need Help
Tips and Tricks

1 Reply

  • Arul's avatar
    Arul
    Super User
    3 years ago

    Lancelot ,

    It should work if you are using the same measures, but there is some data type issue in one of your column used in the measures.

    Thanks,

    Arul