Forum Discussion

SebSchoon1's avatar
SebSchoon1
Post Patron
3 years ago

Measure provide wrong result

Hello all,

 

I have a strange behavior I do not understand,

 

I make multiple measures which are giving me the expected values

 

But then i want to use this result to a final step and it does not work..

 

Here's my report with information

 

 

I say,

 

If [Rank Pour Dispatch] <= [(1) Total des reliquats] Then 1 otherwise Blank()

 

But it does not work, Any idea?

 

Kind regards

 

 

 

Need Help

11 Replies

  • DimaMD's avatar
    DimaMD
    Solution Sage
    3 years ago

    hi SebSchoon1  Try it 

     

    if = If [Rank Pour Dispatch] <= [(1) Total des reliquats],1, Blank()

     


    Without sample data, it is difficult to conduct analyses

    • DimaMD's avatar
      DimaMD
      Solution Sage
      3 years ago

      SebSchoon1 I made changes to this event and the event with the condition worked

      But your data in the picture do not match what you provided

      • SebSchoon1's avatar
        SebSchoon1
        Post Patron
        3 years ago

        Wow,

         

        may thanks for going into this,

         

        it is strange that the date are different

         

        here's another link with two examples

         

        one where it works as expected.

         

        and another one (just below) 

         

        Whioch does not work and i don't no why 😞

         

        https://we.tl/t-6aPbNaUszH