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 n...
Need Help
  • 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

      • DimaMD's avatar
        DimaMD
        Solution Sage
        3 years ago

        Hi SebSchoon1 After examining the fascist sample data, I found that your measure (1) Total des reliquats gives the wrong value. 
        I suggest you use (1)Nombre entier Répartition in your event:

        If(
    [Rank Pour Dispatch] <= [(1)Nombre entier Répartition] && [Rank Pour Dispatch] <> BLANK() , 1, Blank())