locked
Measure % not working as expected RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi All,

    Measure value in source table is 0.015 (data type: real)

    In cube, measure properties are like below

    AggregateFucntion: Sum

    Source: TableName.ColumnName

    DateType: Double

    FormatString:#,##0.00 %;-#,##0.00 %

    --

    Now when I access cube from Excel I see : 1.49999996647238%

    When reporting from SSRS report it shows 1% and correct expected number is 1.5% or 2%

    Any idea, first why and how cube is coming up with that number (1.49999996647238%)?

    Thank you - AK

    Ashok Ojha


    • Edited by AshokKOjha Thursday, July 19, 2018 7:37 PM
    Thursday, July 19, 2018 5:27 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi AshokKOjha,

    Thanks for your question.

    In this scenario, I would suggest you to use "Percent" as the FormatString. This will work both from cube browser and EXCEL.

    Please see a similar blog below:
    https://blog.crossjoin.co.uk/2010/11/03/excel-and-percent-formats-for-calculated-measures/

    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Proposed as answer by Ramakrishnan.lh Friday, July 20, 2018 8:04 AM
    • Marked as answer by AshokKOjha Friday, July 20, 2018 3:26 PM
    Friday, July 20, 2018 1:07 AM