Calculated Item - Solve Order Formula

[Sundance_Kid]

Hi Folks

I have a pivot table.

Column A - shows a list of 12 products
Column B = Revenue from each product
Column C = Profit from each product
Column D = a Calculated Item column dividing column C by column B to get a % margin.

Everything works fine except that for one of the products it does not have a % calculation in Column D for it. When I click on the cell there is no formula, even though the cells above & below have the calculated item formula.
I went to the Calculated Item Solve Order section and in the pop-up I can see the product in the list but there is no formula beside it.

Any idea how I can update it? In the pop up for Solve Order there is only an option to Move Up, Move Down, Delete or Close.

Thanks

 

[mrshl9898]

There isn't a collapsed field by chance? Can you share a screenshot with dummy data if needed?

 

[Sundance_Kid]

There isn't a collapsed field by chance? Can you share a screenshot with dummy data if needed?

Hi, thanks for your reply.

No there was no collapsed field. I ended up deleting the Calculated Item and then adding back - now the cell has the formula in it. Not sure what the issue was.

Thank again