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

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())

 

SebSchoon1's avatar
SebSchoon1
Post Patron
3 years ago

Hello DimaMD 

 

Concerning the measure, it will not work since

 

if i have two items for 3 wharehouse it will not split the remaining quantities

 

since full number is 0 and remaining quantities = 0.67  

 

it will not consider  the total remaining quantities  (0.67 * 3 ) = 2 

 

So it will not work đŸ™‚

  • DimaMD's avatar
    DimaMD
    Solution Sage
    3 years ago

    SebSchoon1 I'm sorry, after looking at your first post, I realized that you are not fulfilling the condition correctly,
    Your condition should be like this change <= to >=

    (1)Attribution des reliquats = If([Rank Pour Dispatch]<>blank() && [Rank Pour Dispatch] >= [(1) Total des reliquats] ,1,Blank())

     

    • SebSchoon1's avatar
      SebSchoon1
      Post Patron
      3 years ago

      Hello,

       

      it does not work, since I'd like to Have Rank 1 As most important priority

       

      :s I think that it must come from my [(1)Total de reliquats ARTICLE]

       

      Wich seems to show results but if fact it is wrong.