ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   retirning count values from calcualted fields (https://www.excelbanter.com/excel-discussion-misc-queries/73233-retirning-count-values-calcualted-fields.html)

Antony

retirning count values from calcualted fields
 
I have built a pivot table that returns a count for both the actual and
planned number of courses completed during a given month. However, now want
to create a calculated field that retruns the difference between the count of
actual and count of planned completions. However as the original data on
which the numbers of completions are counted is in date format I can only get
the pivot table to return a calcualtion of the difference between the dates.

In short what I'm trying to get is

Calculated field= count ('actual complettions') - count ('planned
completions')

rather than Calculated field = 'actual completions' - 'planned completions'



All times are GMT +1. The time now is 01:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com