Forum Discussion

SebSchoon1's avatar
SebSchoon1
Post Patron
3 years ago

Create Specific Rank

Hi Guys,

 

Need challenge for you today! 

 

I have this Table 

 

 

I'd like to Split one available (which is in [Stock]) quantity by [CODE ARTICLE] 

 

However i Have 3 Sizes with Each One quantity in stock.

 

So one of each Size Must go to one unique warehouse! 😛 

 

I'd like to Create an Index Based on each [TAILLE] associated to each [CODE ARTICLE]

 

So i could Share 1 quantity By [TAILLE] Rank   for Each [Rank] by Warehouse !

 

Any way to achieve this?

 

Here is the link to download my sample.

 

https://we.tl/t-9CoSQ8NHkq

 

Thanks guys you roxx!!

Need Help

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    Hi SebSchoon1 

     

    Can you share the expected rank result along with the sample data? Currently I have difficulty understanding the expected result. I don't see "Size" and "Warehouse" in the data.

     

    Best Regards,
    Community Support Team _ Jing