0

Calculation turns wrong after drill-down

Dear all,

the automatically calculated percentage (Create Measure – Percentage of total) calculation turns wrong, if elements of different levels are shown. After a drill-down the new rows get calculated in a “new total” so the percentages of all of the rows are wrong.

Please note that the absloute value of the Grand Total remains correct, but this is and remains the value the percentage calculation should refer to - even after the drill-down.

Kind regards
Markus

4 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 5 yrs ago
    • Reported - view

    Hi Markus,

    Please retest in the new release, 2020.01.121. There is a fix in there described as follows:

    • Fixed an issue where the Percent Of Total context function had an incorrect format when using an In-Memory database

    Hope that helps.

    Ian

      • Senior Consultant BI & Data Management
      • Markus_Loy
      • 5 yrs ago
      • Reported - view

      Hi Ian,

      downloading...

      Markus

      • Senior Consultant BI & Data Management
      • Markus_Loy
      • 5 yrs ago
      • Reported - view

      Hi Ian,

      sorry for the late response, I had some difficulties during installation, because the installer didn't start the WebServer properly.

      Even worse, the problem, this thread is dealing with, is still existing in version 2020.01.121.

      Kind regards
      Markus

    • Senior Consultant BI & Data Management
    • Markus_Loy
    • 4 yrs ago
    • Reported - view

    As this is obviously a bug, I finally posted it to the support.

Login to reply

Content aside

  • Status Answered
  • 4 yrs agoLast active
  • 4Replies
  • 48Views
  • 2 Following