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 đŸ™‚