Data Action - Allocation

[Alebarba]

In the planning model I created a data action that allocates the quantities to the forecast in relation to the quantity ordered. Once the allocation has been carried out, I would like a new data action that allocates only the forecast quantities lower than 1000 TON to the other forecast quantities. it's possible?

Thanks

[William_Yu1 · Accepted solution]

Hi Alebarba, 

    Though you might not able to directly put a value based filter for allocation step, but you may try this: 

1. After the initial allocation step, you can create an advance formula step to move value under 1000 to a dummy member of any dimension. 
2. have a second allocation step to allocation the value from dummy member. 

Best regards, William 

[Alebarba · Accepted solution]

Thanks William, Best regards