# Calculated Item - Solve Order Formula

#### Sundance_Kid

##### New Member
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

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

#### mrshl9898

##### Well-known Member
There isn't a collapsed field by chance? Can you share a screenshot with dummy data if needed?

#### Sundance_Kid

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

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

Replies
2
Views
38
Replies
1
Views
68
Replies
1
Views
34
Replies
5
Views
93
Replies
1
Views
81

1,130,302
Messages
5,641,423
Members
417,209
Latest member
Agbarker

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back