measure result not appearing in cell

[wilster98]

I am trying to add a measure to a Pivot Table.
I have production data that I need to perform calculations on. The calculation is simple Completed qty/start qty+Scrap. The formula check returns no errors. When I click OK, nothing happens. No error, no message just nothing.
The second image shows what the expected result should be. I can manually enter the equation. With measures I end up a blank cell where my results should be. Any help would be appreciated.

Note: I cannot upload the file for Confidentially reasons.

TIA
Willy

 

[alansidman]

I created a simple table and created a Measure using your basic formula. Here is my result

Book5
	A	B	C	D	E
3	Date	Sum of QTY_Complete	Sum of QTY_Start	Sum of Scrap	Manage
4	2/1/2020	100	120	5	5.833
5	2/2/2020	90	100	5	5.900
6	2/3/2020	80	85	1	1.941
7	2/4/2020	85	90	2	2.944
8	2/5/2020	65	78	3	3.833
9	2/6/2020	74	90	12	12.822
10	2/7/2020	36	40	0	0.900
11	2/8/2020	25	30	0	0.833
12	2/9/2020	98	125	10	10.784
13	2/10/2020	100	140	5	5.714
Sheet2

Here is the formula for the measure:

=sum(Range[QTY_Complete])/sum(Range[QTY_Start]) + Sum(Range[Scrap])

I suspect you were missing the parens to separate the "sum" from the field.

 

[wilster98]

I created a simple table and created a Measure using your basic formula. Here is my result

Book5
	A	B	C	D	E
3	Date	Sum of QTY_Complete	Sum of QTY_Start	Sum of Scrap	Manage
4	2/1/2020	100	120	5	5.833
5	2/2/2020	90	100	5	5.900
6	2/3/2020	80	85	1	1.941
7	2/4/2020	85	90	2	2.944
8	2/5/2020	65	78	3	3.833
9	2/6/2020	74	90	12	12.822
10	2/7/2020	36	40	0	0.900
11	2/8/2020	25	30	0	0.833
12	2/9/2020	98	125	10	10.784
13	2/10/2020	100	140	5	5.714
Sheet2

Here is the formula for the measure:

=sum(Range[QTY_Complete])/sum(Range[QTY_Start]) + Sum(Range[Scrap])

I suspect you were missing the parens to separate the "sum" from the field.

Thanks for the reply. That did not work. I even tried a measure that was simply =12+15, no result returned. I'm using the Measures wizard to create the calculation.

 

[alansidman]

Not sure why it doesn't work for you. Here are pictures of what I have. Does this resemble what you have. I have no idea where the Measure Wizard is. I created it manually.

 

[wilster98]

Not sure why it doesn't work for you. Here are pictures of what I have. Does this resemble what you have. I have no idea where the Measure Wizard is. I created it manually.

Thanks for the help. I did some digging. I'm creating the measure in a pivot table. The result appears in the Pivot Table fields, then has to be applied.

 

[smozgur]

@wilster98 - what did you find and how did you actually fix the problem after digging?

Or, @alansidman was right about the SUM function?

I suspect you were missing the parens to separate the "sum" from the field.

Do you mind sharing it with us? Then it is perfectly fine to mark your post as the solution to help future readers.

 

[wilster98]

@wilster98 - what did you find and how did you actually fix the problem after digging?

Or, @alansidman was right about the SUM function?


Do you mind sharing it with us? Then it is perfectly fine to mark your post as the solution to help future readers.

I found a video on LinkedIn Learning that dealt with calculated fields (measures). According to the course, Measures can only be applied to the Pivot Table fields list. I was expecting to see a result in a particular cell.

 

[smozgur]

Measures can only be applied to the Pivot Table fields list. I was expecting to see a result in a particular cell.

Thanks for clarifying.