none
calculated measure behaviour

    Question

  • Hi everybody,

    I work for a customer who has SQL Server 2008 R2 Standard Edition.

    I created a calculated measure which is a ratio.
    Let say NewMeasure = Value1/Value2
    I expected this measure to be calculated like the following example:
    If i have 2 records: value1 = 2, value2 = 3 and value1 = 4 and value2 = 4
    I expect to get such result NewMeasure = 6/7 = 0,85 but I get 2/3+4/4 = 1,66

    Thanks for your help.

    Pete

    Friday, September 13, 2013 6:22 AM

Answers

All replies