Forum Discussion

calerof's avatar
calerof
Impactful Individual
28 days ago
Solved

Allocation failed: Can't perform this action, value cannot be distributed - in MIcrosoft Fabric Plan

Hello,

I have a Planning Sheet with a Forecast column where I manually modified the forecast for specific product categories in the base forecast. When I try to change the value of those cells in the scenario, I get this error: 

"Allocation failed: Can't perform this action, value cannot be distributed."

 

Thanks for any advice.

Cheers,

Fernando

  • First, I had to unlock the children cells.

    Second, as I forgot what row did I enter the manual forecast growth increase formula, I was modifying the child instead of the parent.

    Now it works.

    If I have to delete all this please let me know.

    F

     

1 Reply

  • calerof's avatar
    calerof
    Impactful Individual

    First, I had to unlock the children cells.

    Second, as I forgot what row did I enter the manual forecast growth increase formula, I was modifying the child instead of the parent.

    Now it works.

    If I have to delete all this please let me know.

    F