Sign in
 

none
FILTER EXPRESSION COMPARING DATA TYPES

 > 

    Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I am recieving an error when running my report. I added a filter expression to my chart which only shows data > 24 hours but I am receiving the following error... can anybody help me?

    CANNOT COMPARE DATA OF TYPES SYSTEM.DECIMAL AND SYSTEM.DOUBLE

    Friday, February 07, 2014 1:59 AM
    |

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Irj1985,

    Based on the error message, we can know that the data type of the two values are different. One of them is decimal, another of them is double.

    To trouble this issue, please refer to the steps below.

    1. Ensure that the issue was cause by the filter.
    2. Convert the data type of one of the value to the data type of another value.

    If the issue persists, please elaborate the issue, provide the detail information about the fitler and your report, so that we can make further analysis.

    Regards,

    Charlie Liao
    TechNet Community Support

    Monday, February 10, 2014 8:47 AM
    |
    Moderator