Forum Discussion

Tiff's avatar
Tiff
Helper I
7 years ago
Solved

Created mesure is wrong

Hi everyone ! 

 

On a report, I created two mesures, and the change with the filters (6 filters). 

Then, I want to have a percentage, so I divide mesure1 by mesure2 : 

 

newMesure = [mesure1]/[mesure2]. 

The problem is the newMesure isn't correct ! :o 

I display my mesure1 and mesure2 and the value change with the filter. 

I saw, by modifying the filters that newMesure changes. But it's never the correct value ! If I do my operation on Excel, 616/11408 is not 1.34 % :o 

How can I do ? I checked the filters and nothing... Any ideas ? 


Thank you very much for your help ! 

Tiff

Need Help

9 Replies

  • Tiff's avatar
    Tiff
    Helper I
    7 years ago

    It's really strange... 

    I tried with newMesure = DIVIDE(Mesure1;Mesure2;1), and the result is different from newMesure = Mesure1/Mesure2 ! 
    However, the filters applied are the same.... 

    Thx for your help... 

  • Stachu's avatar
    Stachu
    Community Champion
    7 years ago

    are you sure it's a measure and not calculated column? Calculated column could have the behaviour you describe, as it would calculate % per row and then sum, while measure would sum first and then calculate ratio

    • Tiff's avatar
      Tiff
      Helper I
      7 years ago

      Hi, 

       

       

      Yes, I clicked on "New Mesure" above "new Column", so I'm pretty sure it's really a mesure.... 

      Thank you for your help ! 

      • Tiff's avatar
        Tiff
        Helper I
        7 years ago

        Hi, 

         

         

        See that ? On the right, we can see it's a mesure... 
        On the report, it's writtent that 4384-51=4384 and 11408-616=11255.... 
        The same for the percentage, where 51/4384 is not 1.45 % 616/11408 neither.... 

        I don't know how to do... It is so strange ! And I'm completly stuck for the rest of my work... 

         

        Thannk you for your help, 

        Tiff

  • Tiff's avatar
    Tiff
    Helper I
    7 years ago

    Hi everyone, 

     

    I found my problem, and I don't think I can solve it. 

    The mesure 1 and 2 take their data in different tables. So I have two filter for the date for example, one filter for mesure 1, the other for mesure 2. So, when I adapt the first filter, mesure 1 is correct, but not mesure 2, so the new calculated mesure is wrong. And when I adapt the second filter, mesure 1 is wrong and mesure 2 isn't, so the new calculated mesure is wrong two. 
    I don't see a way to do it differently. 

     

    Thanks for your help

    Tiff