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
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.